SUMMARY

• Professionally strong experience in Business Intelligence (BI), Extract Transform and Load (ETL), relational database systems, SQL, Reporting suite - SSRS, BI/DW architecture and enthusiastic about learning new tools/technologies.
• Experience in Analysis, Design, Development, Testing and Implementation of BI / DW solutions.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Experienced in designing simple to complex ETL solutions to extract, transform and load data to and from various downstream and upstream systems. Implemented BI/DW solutions using SDLC and Agile methodologies.
• Expert in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Informatica ETL.
• Academically experienced in Oracle 11g database administration activities like installation & creation of database, database objects, capacity planning, user management, backup, recovery, data-modeling and database design.

TECHNICAL SKILLS

ETL: Informatica

Query language: (SQL, T-SQL)

Reporting Tools: (SSRS, BO(trained), PowerPivot)

Data Modeling: (dimensional/relational)

Databases: (Oracle, SQL-Server)

Shell scripting: (UNIX, Windows)

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Source Systems Analyst/ Data Analyst

Responsibilities:

• Analyzed sourcing and ingestion requirements for clickstream, website optimization, partner delivery sales, app performance improvement source systems among others
• Analyzed the complexities involved in sourcing external and internal sources to company’s internal infrastructure
• Analyzed file handling and data handling requirements for data load
• Enabled development team’s delivery efficiency by clarifying requirements beforehand with Solution owners
• Performed data security classifications, created documentations for source systems analysis

Confidential, Redmond, WA

BI Analyst / Technology Lead

Responsibilities:

• Led the development of dashboards by interfacing with client to understand & document information needs.
• Translated the requirements (metric, dimension, glossary etc.) to offshore team and collaborated with cross-functional teams to enable technical implementation using custom built reporting solution and SQL Server based backend.
• Translated the requirements to offshore team and collaborated with cross-functional teams to enable technical implementation of dashboards using custom built reporting solution and SQL Server based backend (SSAS, cube, measure and database).
• Worked in scenarios to make data available (decipher the data flow & validate the data per expectations) for end users post extraction & load for datasets such as Cosmos, Flat-files, Azure and relational tables.
• Experienced in designing simple to complex Extract, Transform and Load (ETL) solutions to and from various downstream and upstream systems. Implemented BI/DW solutions using Waterfall and Agile SDLC.
• Created mock-ups using PowerPoint and provided recommendations for optimizations related to UI and implementation
• Created mock-ups and provided recommendations for optimizations related to User Interface and implementation.
• Dealt with web analytics data to bring forth the insights (drive traffic and adoption) for marketing and sales.

Confidential, WA

BI Analyst

Responsibilities:

• Handled BI/DW Testing projects.
• Interacted with key business users, software architects and data architects for understanding project requirements and database design (S2TM, logical and physical data models).
• Scoped and translated the BI/DW Testing requirements, coordinated and managed offshore testing activities.
• Led testing discussions with client and met client quality compliance requirements.
• Performed software documentation (test plans) and carried out quality assurance testing.

Confidential, Redmond, WA

Business Intelligence Developer

Responsibilities:

• Documented knowledge base articles on end to end data flow across upstream and downstream systems so that any potential bugs could easily be tracked to a specific system.
• Provided analysis of O365 payment and software usage data to users.
• Performed root cause analysis by first looking into data, second by transforming the data and third by use of reports and graphs.
• Developed, modified and deployed the SSRS reports to generate metrics, KPIs and scorecards for customer portal of Office 365.
• Used various transformations while mapping the data from source to destination using SSIS.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Provided analysis of O365 payment and software usage data to users.
• Analyzed and interpreted data from various data sources to create reports for various organizational needs.
• Configured and maintained Report Manager and Report Server for SSRS.

Confidential

Data Integration Developer

Responsibilities:

• Ensured that the technical and functional designs meet business requirements, quality deployment and support activities.
• Involved in development, testing, support and maintenance for the ETL processes.
• Analyzed and interpreted data from various data sources to create reports for various organizational needs.
• Performed data profiling on customer data & performed activities like develop, debug, test and maintenance.
• Worked on defining logical & physical data models and ETL mapping design.
• Devised efficient ‘Extract, Transform and Load’ solutions through IBM DataStage for Data Migration.
• Performed ETL testing, created Unit test plan and Integration test plan to test the mappings and created the test data.
• Performed knowledge transfer and mentored team members on ETL techniques.

Confidential

Data Integration Developer

Responsibilities:

• Created and deployed complex ETL solutions (mappings, sessions &workflows) using Informatica to integrate the data between LDAP and Sales force.
• Developed and deployed ETL solutions (mappings, sessions &workflows) using Informatica.
• Worked with Business Users and Business Analysts to communicate the technical requirements to the offshore team and create ETL design
• Analyzed functional specifications, designed technical designs and, created and executed test plans.
• Profiled data with the help of Informatica Data Explorer for getting the information regarding range of data, data types and data frequency
• Created and Run the UNIX scripts for all Pre/Post session ETL jobs.
• Performed peer reviews and mentored team for Informatica deliverables.