SUMMARY

• More than 10 years of experience delivering end to end BI solution.
• Experience in various project phases like business requirements gathering, source to target data mappings, ETL development, testing and production deployment.
• Experience working with Big Data and Hadoop technologies.
• Excellent SQL programming skills.
• SAS Base and Advanced Certified Programmer.
• Excellent understanding of data management principles, Star Schema, Snowflake Schema.
• Expertise working in various domains: Banking, Telecom, Transit, Health Care and Retail industry.
• Ability to deliver tasks within project deadline and contribute in project planning and scheduling.
• Experience working in relational database design, development and testing.
• Full Software Development Life Cycle (SDLC) experience including Analysis, Design and review of Business and Software Requirement Specifications.
• Excellent working knowledge on Data Modeling, Data Integration and Data Mining.
• Expertise handling large data from multiple sources and ability in data profiling, scrubbing, analyzing, integrating and validation from multiple source systems.
• Experience working with AGILE Methodologies.

TECHNICAL SKILLS

Data Warehouse: Big Data, Hadoop, Oracle, Teradata, IBM Netezza and Microsoft SQL Server

ETL Tools: SAS DI Studio, Microsoft SSIS, Informatica, Ab Initio, Pentaho, IBM Data stage

Data Modeling Tools: Erwin Data Modeler and Power Designer

Reporting Tools: SAS EG, Tableau, Microsoft SSRS, SAP BOBJ, MicroStrategy and Power BI

Operating System: Windows, UNIX, LINUX, Macintosh, IBM Mainframe

Languages: SQL, PL and SQL, SAS, Python, Hive, HTML, XML

Testing Tools: Microsoft Test Manager, HP Quality Center

CRM Technologies: Salesforce

Cloud Environments: AWS and Azure

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Analyzing, designing, developing and testing ETL process based on the requirement from business and technical users.
• Analyze data from different source systems and perform data gap analysis to understand which data already exists in target database.
• Provide feedback on the finding of various data trends and gaps to senior management to make informed decisions for data migration.
• Recreating existing etl jobs and reports in SAS 4.2 version to SAS 6.3 version.
• Developed various analytical methods to categorize new customer types that require enhanced due diligence mentioned in the CDD Standard.
• Create test cases and scripts to validate the ETL code developed and test the accuracy of data from legacy systems to new target system.
• Created various reports for AML (Anti - Money Laundering) and CDD (Customer Due Diligence), KYC (Know Your Customer) and EDD (Enhanced Due Diligence) process.
• Create and update existing documentation to support new systems deployed.

Confidential

ETL Developer

Responsibilities:

• Reverse engineer legacy SAS code into actionable requirements.
• Designed and developed complex ETL structures for transformation of data sources into data warehouses.
• Created various reports for AML and CDD and EDD process.
• Worked on creating etl jobs for custom AML scenarios.
• Conducted code and design reviews for suggesting and approval of design specifications.
• Resolved troubleshooting problems relating to ETL applications and data issues.
• Perform in depth data analysis in various sources systems supporting Credit Risk Models.
• Implemented processes for extraction and loading of ETL data into data warehouses and marts.
• Create and document mapping logic to transform source data to usable Credit Risk Model data sets.
• Worked on IFRS9 for gathering requirements and producing reports.
• Maintain macro economic application and load schedules.
• Utilize JIRA to manage work and releases.
• Worked with the MicroStrategy technical support to troubleshoot the dynamic display of prompts in the web mode and some other Report related issues.

Confidential

ETL Developer

Responsibilities:

• Gathering business requirements from business management and creating business rules, logics and conceptual, logical and physical data models.
• Extract and manipulate data from different source systems by developing ETL jobs and feeding in Data warehouse.
• Modifying and Updating incoming data from different source systems using ETL jobs by reformatting, importing, sorting, merging and restructuring.
• Prepare documentation of overall process development from gathering of business requirements, developing of ETL job and test scripts used for data validation.
• Create test cases and scripts to validate the ETL jobs developed and test the accuracy of data from legacy systems to new target system.
• Co-ordinate with offshore team with data mapping, development and testing activities.
• Document test results, log and track defects, and participate in bug review processes to identify priorities.
• Created Attributes, Facts, Dimensional Hierarchies and all the public objects like Metrics, Custom groups, prompts and filters using MicroStrategy.
• Created dashboards, reports, cubes, drill maps for end users to drill down and recover data using MicroStrategy.
• Designed efficient BI Dynamic Dashboards for the business users with dynamic prompt answers and with multiple data sets in both MicroStrategy Desktop and MicroStrategy Web.
• Worked with the MicroStrategy technical support to troubleshoot the dynamic display of prompts in the web mode and some other Report related issues.
• Recommending time utilization plans based on forecasting of developed data.
• Produce and communicate project timelines on a monthly/weekly/daily basis with business management and provide project status.
• Designing and developing project-specific programs like producing analysis datasets, graphics and reports.