SUMMARY

• Over 14+ years of Industrial experience in (BFS) Banking, Insurance, Financial Services and Affiliate sector
• Experienced in BI Development and Testing on banking applications and affiliate marketing
• Experience in agile/scrum /waterfall methodology & SDLC lifecycle.
• Good interpersonal communication skills and excellent organizational skills
• Assigned work to the team and worked on user story and product backlogs
• Extensively worked with large Databases inDevelopment, TestingandProductionenvironments.
• Developed maps and QA metrics designed for efficiency and productivity of the project
• Responsible for architecting data - related solutions, developing data warehouses, developingETL jobs, Performance tuning and identifying bottlenecks in the process flow
• Good knowledge of Business Intelligence, OLAP, OLTP, Dimensional Modelling, Star and snowflake schema extraction, transformation and loading (ETL)process
• Excellent problem-solving skills with a strong technical background and good communication, documentation and presentation skills.
• Involved in Unit Testing, Integration Testing and preparing test cases.

TECHNICAL SKILLS

ETL Tools: Informatica (version 8.6.0), Ab-Initio, Hadoop(podium), Data stage

Reporting Tool: Cognos

Big data: Impala, Hue, Hadoop, Hive in dbeaver

Operating system: UNIX, LINUX & WINDOWS

Data bases: Tera data, PL/SQL, Oracle, DB2, Toad, optimum (IBM navigator), (server)AS400 cockpit.

Data Integration: Informatica, Datastage

Product Suites: Guidewire Policy Center, Claim Center, Billing, auto and residential insurance Center, AS400, rewards cards engineering.

Webased tools: Webpagetest.org Project management Vtiger (CRM), Twiki, Microsoft Test manager, Microsoft tools/ Bug tracking Visual Studio 2015, HP ALM, JIRA systems

PROFESSIONAL EXPERIENCE

BI Consultant

Confidential

Responsibilities:

• Effectively collaborated with other engineers, architects, managers and product managers to solve complex problems
• Discussing with the Client and identify new Tasks/Change Requests.
• Documented the mapping process and methodology used to facilitate future development.
• Responsible for the unit testing and helped in the process of Load testing.
• Participated ongoing maintenance, bug fixing, and quality improvement of the code.
• Direct loads from source to target tables
• Incremental loads using SCD 1& 2, various Informatica component used for transformations.
• Assisting in the design and participating in peer code review to make sure that coding standards are followed.

BI lead

Confidential

Responsibilities:

• Assigned work to the team and experienced in user story and product backlogs
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Created detailed Test plans to check the functionality of Guidewire policy and claims policy center.
• Experience in Data Analysis, Data Cleansing Scrubbing, Data Validation and Verification, Data Conversion and Data Migrations
• Experienced in using the TOAD, optimum (IBM navigator) features for loading the data from various Source as AS400 to Target tables in Hadoop and Hive database.
• Planned for particular release and obtain necessary technical requirement. Such meetings include, design review, test execution timeline.
• QA metric designed for efficiency and productivity of the projects.
• Participate in technical working sessions such as requirements definition, functional walkthroughs, technical design reviews, change control sessions and stakeholder meetings

BI /Mobile application

Confidential

Responsibilities:

• Worked on various online affiliate marketing white labels dealing calculations, AD/media/campaign strategies
• ETL methodology for supporting data Extraction, transformations and loading process in a corporate - wide-ETL solution using SQL service and Informatica as an etl tool.
• Created test plans and test scripts, executed test scripts and wrote test report using Microsoft test manager (Exploratory testing)
• Performed Code comparison in Microsoft visual studio after the built was made in Team foundation server (TFS)
• Updating document on the twiki s, vtiger, Microsoft test manager and keeping up to date track of bugs
• Tool testing based on the geo-location functionality tests and mobile testing
• Involved in the feasibility analysis of the Project requirements.
• Received various appreciations for quality delivery, improving their capital.

System Engineer

Confidential

Responsibilities:

• Developed and Tested Graphs based on the business requirements.
• Creating mapping documents based on requirements and assisting the lead with the timelines.
• Developed maps, workflows and executed mappings for large volume of data using various ETL tools such as Ab Initio and informatica.
• Developed functional and Unit test cases created by reporting tool Cognos.
• Received reward of appreciation from the client Confidential . Good understanding of Requirements Definition, Solution Implementation within the time constraint.

Abinitio Developer

Confidential

Responsibilities:

• Focal point to communicate with the “rewards card engineering credit cards” business and gather requirement from BRD.
• Developed maps for data cleansing, data validation and data transformation and performed feasibility testing of the current scope usingAb Initio components.
• Performed migration of data from a variety of sources into EDW Teradata.
• Used Toad to verifythe counts and resultsof the graphs.
• Tuning of Ab Initio graphs forbetter performance.
• Process and Transformdelta feedsof customer data, which comes in daily.

Informatica Developer

Confidential

Responsibilities:

• Developed Maps and workflow in Informatica to load data from different sources like flat files into STARS Sybase and in turn used staging tables in the informatica ETL to load customized cleansed data into Salesforce CRM (customer relationship management) if needed by the business.
• Used Informatica Workflow Manager & Workflow Monitor and server to read data from sources to write to target databases using various transformations like filter, joins, group by.
• Performance tuning was done on complicated mapping.
• Have experience in scheduling and testing initial and delta daily loads.
• Performed Unit testing, reporting of defects and Fixing the Defects
• Worked closely withmigration team to migratethe ETL code changes from development environment to System, Integration and Production environments