SUMMARY

• A Seasoned Professional with around 9 years of IT / consulting experience in Software Development Life Cycle (SDLC) that includes requirement gathering, designing, coding, testing and deployment in Data warehousing.
• Around 5 years of technical lead experience in Data warehousing primarily using Business Intelligence tools such as Informatica, SSIS ETLs and Microstrategy reporting.
• Technical and Functional experience in Data warehousing - Implementing ETL (Extract, Transform and Load) using Informatica Power Center 10.1/9.5/9.1/8.1/7.1 and Microstrategy reporting
• Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes through Informatica and SSIS.
• Translates customer requirements into operational strategies associated with each solution and offering to ensure client needs are met in a cost-effective and timely manner.
• Performed project level design, data analysis and application performance analysis. Demonstrated ability to clearly articulate technical designs in written communications.
• Extensive experience in ETL Design, Development, Testing and Production support phases.
• Strong Data warehousing conceptual/practical knowledge including star schema dimensional modeling and snowflake schema dimensional modeling.
• Extensive experience in creation of complex informatica Mappings using mapplets and reusable transformations.
• Proficient in Database partitioning, Tuning and Performance tuning in Informatica.
• Sound understanding of Push down Informatica mappings to Hadoop/Hive Environment using Informatica Big Data Edition.
• Knowledge of Big Data concepts such as Hadoop Distributed File System and Hive
• Strong Experience in UNIX Shell scripting.
• Experience in Microstrategy Reporting Development/Enhancements
• Extensively worked in creating and integrating Microstrategy reports/documents and objects (Attributes, Filters, Metrics, Facts, and Prompts) with the data warehouse
• Created complex Reports in Microstrategy Desktop using features like custom groups and consolidations.
• Good understanding of Core Java concepts.
• Experience in Actuate report development/enhancements
• Excellent Business Analysis skills, communication skills, problem solving skills and presentation skills.
• Experience with Code Version Control systems like GIT, SVN.

TECHNICAL SKILLS

Operating Systems: Windows 10/7/XP and UNIX(HP-UX, AIX, Linux)

Databases: Oracle 11g/10g/9i, DB2 9, Netezza, SQL Server 2008/2012, Informix

ETL: Informatica Power Center 10.x/9.x/8.x/7.x, Informatica Big Data Edition,SSIS

Languages: SQL, PL/SQL,C,C++, Java and UNIX Shell Programming

Reporting: Microstrategy 10/9/8.1.1, Actuate

Code Version Control: SVN, GIT

PROFESSIONAL EXPERIENCE

Confidential

ETL Consultant

Responsibilities:

• Worked on Client Reporting Center (CRC) DW, central data warehouse with data marts which loads full daily volumes from Prime Brokerage Applications and reference data sources and other systems and reporting infrastructure for a variety of downstream client reporting.
• Analyze the stories and task assigned in JIRA and come up with conceptual solution of the change along with high level impact analysis to the system / code components.
• Based on the above provide effort estimates for the task.
• Develop the code using bank standard tools. Informatica Powercenter tool set, UNIX shell scripts to pre-process files, PL-SQL for writing stored procedures on Oracle Exadata.
• Perform extensive testing of the code and impacted system components to verify the reliability of the code on boundary conditions and negative functional scenarios.
• Execute Integration testing of the components to ensure the end to end production like test.
• Work on the defects assigned in JIRA identified during testing phase, technically analysing them and implementing fix.
• Coordination with the implementation teams to deploy project in production environment.
• Worked on enhancing the existing Oracle Stored Procedures as per requirement.
• Worked on decommission of the legacy technology processes and converting into Informatica Platform by developing new mappings.
• Experience in complex XML transformations and Java transformations.

Confidential

Sr.Consultant/Technical Lead

Responsibilities:

• Leading the Marketing/BI domain for 5 years which supports all Loyalty customer centric systems and Sales and Transaction Data warehouses.
• Successful implementation of various projects /enhancements related to Loyalty Customer related changes and Data ware house related changes.
• Worked with business/client to capture the requirements and translates them into operational strategies associated with each solution and offering to ensure client needs are met in a cost-effective and timely manner.
• Estimation of pre-analyze and post-analyze sizing that included resource allocation, timeframe assessments, funding and warranty support meant for the ETL activities carried out for the projects involved.
• Involved in designing and developing mappings based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Enhanced the SSIS packages for the load of sales/tranasaction data into reporting DW for MSTR reporting.
• Built the Microstrategy Schema including the Hierarchies, Facts, Attributes, transformations and child-parent relationships of attributes
• Designed and developed reports using Advanced Metric Objects, Filters, and Prompts and hence providing users with the facility to create customized reports by creating their own filters and templates.
• Generated Freeform reports for faster and better performance of the system as per the user requirements
• Optimized the SQL performance of the reports using the VLDB properties.
• Worked on converting Legacy Actuate Reports to Microstrategy Reports.
• Developed UNIX shell scripts which invoke Informatica mappings and development of UNIX scripts for reporting/extracts purposes.
• Performed code reviews on Informatica platform to ensure the results are as per requirement & design oriented.
• Involved in promotions of the code from DEV/UAT/SIT/Prod. Deployment documentation was done and produced for all the ETL jobs
• Participated in test execution of projects involved and supported UAT in fixing data issues.
• Strong exposure of handling offshore and onshore team.
• Prepared management-level reports to provide briefings, utilization and capacity plans, staffing projections, budget estimates and financial forecasts
• Ensured appropriate allocation of resources to support project demands and coordinated team activities to ensure all deliverables are completed on time, on budget and within quality standards.
• Maintains and supports all applications falls under the Marketing domain
• Successfully implemented solutions to improve the performance of the long running business critical processes.
• Involved in developing Microstrategy reports, documents and objects and provided support of any customer queries.
• Enhanced existing Actuate reports and developed new actuate reports as per business requirements.
• Worked as both Individual contributor and technical lead for the involved projects.

Confidential

Software Developer

Responsibilities:

• Involved in Analysis, Design, Development and Unit Testing .
• Preparation of Technical Design Document.
• Designed and Developed Mappings, Sessions and workflows using Informatica
• Used UNIX shell scripting for reconciliation jobs, cleansing the source files, Job controls, generate dynamic parameter files.
• Development of UNIX scripts to create extracts/reports as per business requests.
• Performed peer reviews for code and test cases for the completeness
• Actively participated in fine-tuning of long running SQL's and ETL’s.