SUMMARY:

• Having 11.5 years of experience in IT as a Data warehousing and BI Professional.
• Extensively worked on the BI Tool Microstrategy 10.4 in developing reports, dashboards and documents.
• Used advanced Microstrategy reporting features like VLDB properties, object prompts, drill maps, prompted filters and advanced metrics.
• Extensively worked on ETL tools like INFORMATICA POWER CENTER 9.x, 8.x and 7.x.
• Worked on complex ETL and data warehousing solutions performing data analysis, impact analysis, source to target data mapping, functional and high level design.
• Worked on Data Extraction, Data Transformation and Data Loading
• Knowledge of Data Warehousing concepts
• Knowledge of importing data from different data sources like Excel files and creating an intelligent cube and creating reports that run against the cube.
• Expertise in implementing a full Software Development Life Cycle (SDLC)
• Good SQL skills and familiarity with databases like Oracle, SQL Server and Teradata.
• Strong MS excel Skills - Pivots, Lookups, Formulas and Macros.
• Project Methodologies - Agile, Waterfall
• Strong BA skills to elicit requirements from/engage with stakeholders for project implementation
• Strong presentation skills and the ability to communicate at different levels within the organization with exceptional problem-solving and analytical skills and excellent attention to detail
• Experience in interacting with clients directly to gather requirements and implement functional and technical aspects of analysis and design

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6/8.6/7.1.1

Database: Oracle 10g/9i/8i, MS SQL Server

Reporting Tools: Microstrategy 10.4

Operating System: Windows NT/2000

Languages: SQL

Industry: Banking and Financial Industry

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte

Senior Associate Consultant

Technical Environment: Informatica 9.6.1, Microstrategy 10.4, Oracle, SQL Server, Autosys

Roles & Responsibilities:

• The project involves extensive Financial Reporting with the end user tracking the Project Burn and Available Funding through very precise Reports. Initially in 2013 the reports were executed in Excel with macros involving complex SQL Queries connecting to the Backend database and retrieving the data.
• As Excel reporting was very manual intensive, took the leadership and whole responsibility to convert all the reports into Microstrategy and thereby schedule and distribute to the end users.
• Involved in in-depth analysis, design and development activities starting from Source to Target data analysis (Source - Oracle and SQL Server Database, Target - SQL Server), Data Modelling(Star / Snowflake Model), Data mapping, ETL Development and Generating reports/dashboards/documents in Microstrategy.
• Developed Mappings involving SQL and Oracle Source tables and transforming the data using various transformations like Lookup, Routers, Normalisers, Filters, Expressions and Joiners.
• The entire business logic of the reports is implemented in Microstrategy. Created a well structured and well defined data model and was involved in documenting the Low level design for creating the Scheme objects -Attributes, Facts, Relationships and Hierarchies.
• Developed Reports using nested prompts, Report and View Filters, Grand Totals and Sub totals, Thresholds, Drill maps, Templates, Advanced Metrics, Smart Metrics, and Searches.
• Expertise in analyzing the back end SQL query and optimizing the report results using various VLDB settings to manipulate Joins, Select/Insert Statements and Metrics to improve the overall execution time and throughput of the reports.
• Created user interactive reports with object prompts and Search functionality whereby a report having n number of columns could be customized with respect to end user requirements. Object prompts were created for Attributes, Metrics and Filters.
• Completely responsible for end to end testing of the reports for standard naming conventions, Metric Totals Calculation, SQL query validation, Threshold testing, Formatting/Export Functionality testing, Drill options testing etc.
• Created Documents and Dashboards using panels and panel stacks with several datasets and a combination of graphs, grids and pie charts.
• Expertise in advanced formatting of the reports on the Microstrategy Web version and thereby Exporting the data into Excel or PDF for the end users and Subscribing and scheduling the reports to the History list.
• Worked with Documents in Design mode, Interactive mode, Flash mode and Editable mode.
• Extensively trained the end users on how to view, format and export the reports from Microstartegy web and also to save the reports on to their My Reports folder for further processing. This was a very good learning experience and a challenging process since users had to quickly adopt Microstrategy reports over Excel reports.
• Received several Client Appreciations for successfully converting the reports which contained important Financial data into Microstrategy and having an in depth knowledge of the source systems and how the data flows and translates to form precise meaningful reports.

Confidential

Technical Analyst

Environment: Informatica 7.1.1, Oracle, Unix, Clearcase and Autosys

Roles & Responsibilities:

• Requirement analysis, Detail Design, High Level Design and preparation of Unit Test Plans.
• Development of mappings based on the data model with extensive usage of transformations like filter, aggregator, update strategy, lookup, Union, Joiners, Routers and Normalizers.
• Worked directly with the client to understand the business requirements and taking the lead in dividing the development and migration activities between the team to ensure that the application is delivered well within time limits.
• Adapted well to the sudden shift of project from Water cycle to agile methodology. Kept up with the challenge of delivering code within each short sprint.
• Developed workflows having multiple tasks and sessions and involved in writing parameter files and jobs.
• Participating in peer review of Informatica objects
• Coding & testing the Informatica Objects as per client’s ETL standards
• Involved in Unit Testing, Integration Testing and System Testing

Confidential

Senior Software Engineer

Environment: VC++, Visual Basic (VB), Oracle, Harvest CC tool, Quality Centre

Roles & Responsibilities:

• Analysis of the Business Requirement Document.
• Preparing Low level Design and unit/ SIT test cases for the entire application.
• Development of the user interface using VC++. Used some of the more advanced features and implemented the interface using tabs.
• Involved in Unit Testing, Integration Testing and System Testing
• Gained and experienced practical knowledge to deal with each and every phase of a typical software development life cycle.

Confidential

Software Engineer

Environment: VC++, Visual Basic (VB), Oracle, Harvest CC tool, Quality Centre

Roles & Responsibilities:

• Enthusiastically began the development career by converting all the OOPs concepts gained during the training into actual VC++ code.
• The UI contained complex components like Tabs and multiple window panes and was involved in understanding the functionality and coding accordingly.
• Involved in Unit Testing, Integration Testing and System Testing
• Received the spot award for best performer of the quarter in the first 6 months after joining the company.