SR. ANALYTICS CONSULTANT
WELLS FARGO
Total years of experience :15 years, 1 Months
Wells Fargo & Company is an American multinational banking and financial services holding company which is headquartered in San Francisco, California, with "headquarters" throughout the country.\[5\]
Hardware/Software: MS SQL Server 2008 R2, SQL SERVER 2012, SQL Server Data Tools, Agile Model Developement, T-SQL, PL-SQL Oracle Server, Toad for Oracle, SQL profiler, MDX, SSIS Expression Language, CMD prompt, SQL Server Configuration Tools, Toad for SQL Server, SQL Compare
Responsibilities:
Structured development life cycle and implemented process methodologies
Expertise in building ETL Process, Data marts, OLAP Cubes, Data visualization, online service tool, and Stored Procedures.
Creation of cubes, dimensions and business critical KPIs using SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
Creation of several MDX queries according to business requirements.
Creation of SSAS analysis services processing tasks, cube processing options and roles according to the business requirements.
Capable to develop centralized reports/cubes and KPI’s to improve business processes
Experienced in consulting and providing guidance to business partners and application users to build business rules, define data pulling logic, metrics, measurements and results
Skilled in source data research, data integrity, data validation and data analysis
● Develop and demonstrate POC on CUBES and ETL strategies to client.
● Help in data modelling efforts to decide on various entities and relationship between them.
● Use TFS (Team foundation server) source control tool to check in all of the codes in daily basis.
● Used AGILE and waterfall SDLC process.
Client: Nokia Siemens Networks (Financial and Reporting applications and Business Intelligence)
The system helps as a Reporting tool for sales margin, Trend Analysis, Inventory management and profit Estimation based on historical information. HWS BI Toolbox application is heavily used by the NSN HWS community, including internal and external collaborators. It provides a full range of services in various categories like Supply, Repair and Return.
POC Tool:
This is a .Net based Project management system that is used for calculating the
Project completion status and Revenue Cycle Management for monthly reports that is shared across NSN Management.
• Database Designing, Development of the Data Marts, and Data Modelling of new Data Mart.
• Develop and improve Microsoft Analysis Services cubes
• Generation of Interactive reports and Trend analysis using SSAS, SSRS reports.
• Development of Cube data and Partitioning of the Existing Cube structure and performing KPI Calculations using MDX Queries.
• Understanding the needs of the customers and implementing the desired needs.
• Using SSIS Tasks for Data loads into data mart and Cube processing.
• Implementing Drill down Reports and Report Scheduling activities.
• Provided technical support to the team for critical and complex requests.
• Migration of the existing ASP.net based applications to reporting based applications such as SSRS Reports.
• Monitoring the Production Servers Using WMI tasks in SSIS and reporting for any issues.
• Bug Fixing in the Existing application and performing enhancements.
• Writing Stored Procedures and other TSQL functions for Performance tuning of the existing applications.
• Involved in developing, testing custom client side applications related to Financial and Applications and other Reporting System development using SSRS, SSIS and SSAS.
• User Interaction and relationship management with the customers globally.
• Working with Oracle Sql, Pl/sql in a highly challenging environment and performing complex calculations using Oracle 11g
Hardware/Software: MS SQL Server 2008R2, MS SQL Server Analysis Services 2008R2, Integration Services (SSIS), T-SQL, MS Excel, Tortoise SVN, Waterfall Environment, , SQL profiler, MDX, SSIS Expression Language, CMD prompt, SQL Server Configuration Tools, Toad for SQL Server, SQL Compare
Client/Company : Wellpoint Inc
Project : Wellpoint (.Net 2.0 and Sql Server 2005)
Wellpoint Inc is one the largest managed healthcare company in USA,
Groups and individual members can select from basic as well as comprehensive plans to meet their specific needs.
• Co-ordination with clients and team to resolve any clarifications
• Development of the business needs based on the requirements.
• Involved in production deployment and server migration tasks.
• Resolved production bugs, support release process as needed
• Resolved technical issues with other teams
• Demonstrated the enhancements during release to the clients.
• Analysis of the specifications provided by the clients for Enhancements
• Involves in Unit testing & Integration testing
• Supporting the system in various environments like Staging, QA and Production.
Client/Company : MICROSOFT
Project : MS-ASM-RXD-SALES
Siebel is a customer relationship management tool to manage the partners and their critical information.
• Resolved production bugs, support release process as needed
• Involved extensively in management of partners and customers.
• Close Interaction with the customers and partners of Microsoft worldwide.
• Understanding the needs of the customers and resolving the issues.
• Demonstrated the enhancements during UAT and release to the clients
• Provided technical advice to the team for critical change requests.
• Communicate with SME'S from Microsoft and gather the requirements and perform the activity.
• Closely monitor the applications and give immediate resolutions for the discrepancy faced by the customers
• Involved in the Performance Tuning of the existing application
• Demonstrated the enhancements during UAT and release to the clients.
EXPERIENCE IN ORACLE/PLSQL
Over 2 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) and UNIX.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Expertise in Client-Server application development using Oracle 11g/10g/9i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Creation/modification of database objects like Tables, Packages, Procedures, Functions, Triggers, views, Sequences, Synonyms.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Experiences using PL/SQL Collections, Ref Cursor, and Bulk collect, Pragma Autonomous Transaction and Oracle Supplied Packages.
Exposure in creating Dynamic SQL, Dynamic Ref Cursor and Global Cursor with Package.
Involved in resolving production problems for the applications and ensure all support Service Level Agreements.
Worked in Telecom and Healthcare domains.
Experienced with UNIX including basic commands and shell scripting.
Technology management, The courses are divided into four semesters, gradually moving from basic to more technical subjects. The curriculum includes core courses like, Technology in the Business Environment Corporate Finance Management of technology Project management Marketing analysis Technology and the Law Strategic Planning and Marketing Web technologies Systems analysis