SUMMARY

• Provide technical expertise throughout all phases of the system data integration life cycle (including requirements, analysis, design, implementation, resource deployment, performance tuning, testing, and support) on Waterfall and Agile platforms.
• Collect requirements by interviewing business users, analyze source systems, database and develop specification documents.
• Estimate the time and scope of specific business intelligence projects (e.g. Business Performance Reporting, Dashboards, Data Analytics, Visualizations, Score cards, Data sourcing, Data Profiling etc.);
• Design, Develop, Test, and Support Business Intelligence semantic layer, building blocks, reports, dashboards using industry standard tools such as Cognos, MicroStrategy, SQL, SQL Server Integration Services (SSIS), Tableau, etc.
• Analyze test results and performance reports to verify software efficiency and eliminate programming errors to ensure uninterrupted data reporting.
• Writing, updating, and maintaining complex computer software and data integration program packages for Business Intelligence Systems, utilizing programming languages.
• Integrating data from various sources to make it accessible and retrievable across a broad range of user interfaces by end users.
• Developing, testing and supporting protocols for data quality, data integration, data management, data warehousing (in Kimball and Inmon styles), and data extract - transform-load, utilizing specialized industry tools (e.g., SSIS, Informatica, MicroStrategy, DB2 SQL, Oracle PL-SQL etc.) to ensure an accurate data gathering and reporting environment;
• Providing Administration for Business Intelligence Systems infrastructure.
• Provide Level 2 and 3 support for the application using - MicroStrategy, Linux, command scripts Informatica, Oracle, SSIS, Talend, DB2 to build Extract Transform Load (ETL) routines, Web services.
• Resolve production support incidents, participate in Change Management process, Knowledgebase maintenance, release deployments.
• Created and executed project work plans and revised plans as appropriate to meet the ever-changing business needs and requirements. Used formal SDLC project methodology
• Analyzing test results and writing performance reports to verify software efficiency and eliminate programming errors to ensure uninterrupted data analysis and integration.
• Learning and applying the latest technologies to deliver the highest-quality products and services.
• Collaborating with all computer professionals to maximize resource development, knowledge base development, and training and performance management; and
• Managing relationships with clients and providing on-going software support to clients.
• Expertise in installation, design, development, administration and testing of data integration solutions built with Informatica products suite.
• Extensively worked on Informatica designer components - Source analyzer, Transformation developer, Mapplet and Mapping Designer.
• Hands on experience with complex mappings from varied transformation logic like connected and unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc.
• Experience in creating UNIX shell scripts to automate processes.
• Created Documentation (Runbook, Technical Design Document and Low-Level Design Document) for supporting the Application using Microsoft Word, Visio.
• Proficient in writing complex SQL queries using complex SQL features such as correlated subqueries, hierarchical queries, analytical queries etc.
• Good Knowledge in Dimensional Modeling, Star Schema & Snowflake Schema. Very good knowledge on the DWH Architecture (end to end flow: ETL to Reporting)
• Expertise in MicroStrategy Desktop Features includes integrating of MicroStrategy reports with objects includes Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups and Intelligent Cubes.
• Extensively worked on designing schema objects includes creation of Facts, Attributes, Hierarchies, Logical Views and Transformations

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10,9.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager), SSIS

Databases: DB2 v8.1/8.7, Oracle 11g,12c MS SQL Server 2012/2017, MySQL, Sybase

Data Modeling: Erwin, MS Visio

OLAP Tools: MicroStrategy 9x/11.0

Database Tools: Toad, SQL Developer, Squirrel

Languages: SQL, PL/SQL, UNIX Shell scripting

Process Modelling: MS Visio

Version Control: Team Foundation Server

Release Management: Jira and Confluence

Other Tools: HP Service Center, HP Service Manager, Service Now ticketing and Google Cloud Computing, GlobalScape Enhanced File Transfer (EFT) and HP ALM (Application Life Cycle Management)

PROFESSIONAL EXPERIENCE

Confidential

ETL Architect

Responsibilities:

• Designed and developed a data model solution for Retail analytics reporting.
• Provided System and Application Administration for Informatica PowerCenter
• Developed UNIX shell scripts for flat file pre-processing tasks and transferring the files to ETL server.
• Created DDL’s for the DB tables, views and used them according to the new business requirement.
• Performed detail data analysis of both data elements requested by the business and data source and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure, SQL transformation, Router, Connected & Unconnected lookups, Union, Expression and Aggregator transformations.
• Convert Promotion XML data files into Oracle PL/SQL rows and columns used the options such as SQLLOADER, utl file, and XML CLOB which will be used in the KPI reports.
• Developed Re-Usable Transformations, Functions and Mapplet.
• Responsible for Unit testing, System testing and Integration testing of mappings and workflows.
• Involved in Code migration.
• Created and maintain technical documentation including operations run books, user guides, and standard operating procedures

Environment: MicroStrategy 10.1, Windows XP, UNIX AIX, Informatica 10.1, DB2, GlobalScape Enhanced File Transfer (EFT), Sybase

Confidential

ETL Developer

Responsibilities:

• Used ETL Informatica tool to develop jobs for extracting, cleaning, transforming, and loading data into RBI data warehouse.
• Used advanced transformations like Java,XML and HTTP to send the webservice request and process/parse the Json and XML files to DDM Data warehouse.
• Created databases and schema objects including tables, indexes, views, functions, synonyms and applied constraints, connected various applications to the database. Build dimension table surrogate key management system.
• Created linked server to connect to the source system which was for building the RBI Audit reports.
• Used team Foundation server for version control and deployed the code using SQL server project deployment model.
• Created scripts using WinSCP to compress and transfer the files to FTP server.
• Created command line shell scripts for automatic triggering of reports from the BI application after completion of the daily/hourly loads.
• Create Triggers, Functions, stored procedures in SQL server to transform the data from staging layer to RBI warehouse.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Configured database email and Implemented automatic ticket generation process in Service now for effectively tracking the Failures.
• Created project documents which includes SOP, Design document and User training document.

Environment: MicroStrategy 10.1, Unix AIX, Microsoft SQL Server 2012, SQL Server Integration Service, SQL Server 2012/2017, MicroStrategy 10.x, Business Intelligence Development Studio,DB2,Oracle

Confidential

MicroStrategy Report Developer /ETL Developer

Responsibilities:

• Created MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and Architect.
• Moved Objects from one environment to other.
• Creation of Interactive Dashboards in reports & utilized the new features to convert the dashboards into Flash mode.
• Created Complex Metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports
• Tracking enhancement projects to ensure the project delivery on time.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure, SQL transformation, Router, Connected & Unconnected lookups, Union, Expression and Aggregator transformations.
• Extensively worked with both Connected and Unconnected Lookup Transformations.
• Responsible for Unit testing, System testing and Integration testing of mappings and workflows.

Environment: MicroStrategy 9.4.1, SQL Server 2012, Windows XP, UNIX AIX, Informatica 9.6, DB2, GlobalScape Enhanced File Transfer (EFT), Sybase, Service Now