SUMMARY:

• Around 4 years of IT experience in all stages of Software Development Life Cycle (SDLC) Business/Data analysis, ETL Development, Data Modeling, Project Management, Data Modeling, Data Mapping, Build, Unit testing, System Integration and User Acceptance Testing.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Configuration Management.
• Experience in design and development of Data Warehouse and business intelligence solutions using ETL tools like Informatica, Talend Data Integration, DataStage, Pentaho and SSIS.
• Have Business knowledge on Dynamic CRM for Electric and Gas customers, payroll and Insurance for production employees.
• Proficient in the Integration of various data sources with multiple relational databases like MS SQL Server, MYSQL, Oracle11g, DB2, XML files and Flat Files into the staging area, Flat Files into the Dynamics CRM, Data Warehouse and Data Mart.
• Expertise in all areas of software development methodologies (Waterfall and Agile) including client interaction, requirements gathering, analysis and tele - conferencing with the client during the progress of the project .
• Made use of all stages of Data Aggregation, Sorts, Merges, Joins, Change Captures, Peek stages in Data Loading jobs.
• Used Data Stage Manager to import/export Data Stage projects and jobs to define table definition in repository.
• Used Data Stage Director to debug, validate, schedule, run and monitor Data Stage Jobs
• Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts.
• Dimensional data modeling using Data Modeling, Star Join Schema/Snowflake modeling, fact and dimensions tables, physical and logical data modeling.
• Good Knowledge in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.
• Involved in Performance Fine Tuning of ETL DataStage programs.
• Involved in Logical and Physical Design, Backup, Restore, Data Integration and Data Transformation Service.
• Data Migrations using SAP Data Migration Framework/AIO Methodologies following full ETL processes to ensure successful migration of data from legacy systems to SAP.
• Experienced in Oracle database design, PL/SQL application development and back-end development using DDL, DML commands, SQL Queries, Table Partitioning, Collections, Import and Export data, Stored Procedure, Cursor, Functions and Triggers and Dynamic SQL using PL/SQL with advanced PL/SQL techniques.
• Functional knowledge on data models, database design development, data mining and segmentation techniques.
• Proficient with many different types of RDBMS, such as MySQL, MS SQL, PostgreSQL and NoSQL like MongoDB and Cassandra.
• Good knowledge of Java Object Oriented Programming concepts (OOPS).
• Hands on experience with Core Java with Multithreading, Concurrency, Exception Handling, File handling, IO, Generics and Java collections.
• Extensively used JIRA for project management especially in Agile/Scrum environment.
• Have delivered large-scale solutions, coordinated projects with both Onshore and Offshore teams.
• Involved in daily Scrum meetings to keep track of the ongoing project status and issues.
• Used GIT for version control and regularly pushed the code to GitHub and Bitbucket.
• Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and written communication skills.
• Independent, enthusiastic team player with strong adaptability to new technologies.
• Excellent communication & interpersonal skills with proven abilities in resolving complex software issues.

TECHNICAL SKILLS:

PROGRAMMING LANGUAGES: SQL, PL/SQL, T-SQL, Python, HTML, CSS, JavaScript, Java, C, C++.

ETL TOOLS: Pentaho, Talend, Data Stage, Informatica, SSIS, SSRS.

METHODOLOGIES: Test Driven Development, Agile, Waterfall.

PACKAGES: MS Office, Erwin, Matlab.

DATABASES: MS SQL Server, MYSQL, Oracle 11i, Mongo DB, Cassandra, DB2.

FTP/SFTP:: FileZilla, WinSCP, Putty

VERSION CONTROL: GIT, CVS, Tortoise GIT

OPERATING SYSTEMS: WINDOWS, LINUX, MAC, UNIX

OTHER: Shell Scripting, UNIX Scripting, Tabulae, SAP ECC, SAP BOADS.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Data Lead/ ETL Developer

Roles & Responsibilities:

• Implement Data Integration process between large database and Dynamic CRM, Flat file and Dynamic CRM with SSIS integration tool.
• Develop ETL mappings for flat-file data sources (XML, .csv, .txt) and loading the data from these sources into Dynamic CRM portal with SSIS tool.
• Responsible for one-time data migrations into newly developing Dynamic CRM portal.
• Monitoring of current data flow from previous client’s database via SSIS tool to new Dynamic CRM Sales force portal. Routinely resolving data conflicts via ETL error log files including potential matches.
• Worked with team and client closely and prepared the data mapping document.
• Have Knowledge about the Dynamic CRM and the business analysis.
• Used SQL to extract and analyze customer data from different modules like accounts, premise, sites etc. to identify key metrics transforming raw data into meaningful insights.
• Created dashboards in Excel and Tableau for data interpretation and reporting by using Pivot Table and VLOOKUP for various releases to track the execution status of different modules.
• Create source-to-target data mappings for ETL systems, including edit, validate, and transformation rules. Also created business logic for the systems by analyzing client requirements and designed the ETL mappings with them.
• Performance Tune Data sources, targets, mappings and sessions to overcome bottlenecks in data migration performance.
• Create data transformations and mappings from scratch.
• Work with Business Analysts and users to understand data requirements, layouts, and look and feel of data reports and dashboards.
• Prepared Use cases and Look-and-Feel documents for Data Requirements, reviewed them with end users.
• Created transactional based data dashboards using actual orders and target orders, complete with Trend lines and table calculations to see the difference between each quarter.
• Created & Implemented MS SQL Database Components, Databases, Tables, views, Constraints, Stored procedures, Views and Functions.
• Generated T-SQL scripts for Data retrieval, Manipulation & Validation for various applications.
• Involved in Performance Optimization of Queries & Stored Procedures by analyzing Query Plans, blocking queries, Identifying missing indexes etc.
• Gathered end user requirements for data and worked with the DBAs to meet end Client specifications.
• Analyze the Business Requirements, Functional Specification, Use Cases and Configuration Spec Documents for Data related items.
• Wrote & debugged SQL scripts.
• Created end user and internal analytical reports from complex SQL queries.
• Created and implemented staging databases for data warehouses.
• Was responsible for data-related defects for the Defect Management Team. Presented defects and fixes to the Business, Project and Management Team.
• Coordinated database maintenance activities with the off-shore Application Teams and scheduled necessary scrum calls and technical sessions.
• Reviewed and provided feedback on data-related project deliverables.
• Performed knowledge transfer to technical personnel for data-related items as necessary.
• Ensured delivery of bug free databases to the Production Applications and supported QA and UAT testing activities.

Confidential, CA

Data Integration Engineer

Roles & Responsibilities:

• Implement Data Integration process between large databases with Pentaho and Talend Integration Suites.
• Design, develop and deploy end-to-end Data Integration solutions.
• Develop ETL mappings for flat-file data sources (XML, .csv, .txt) and loading the data from these sources into relational tables with Talend ETL.
• Create source-to-target data mappings for ETL systems, including edit, validate, and transformation rules. Also created business logic for the systems by analyzing client requirements and designed the ETL mappings with them.
• Performance Tune Data sources, targets, mappings and sessions to overcome bottlenecks in data migration performance.
• Create data transformations and mappings from scratch.
• Work with Business Analysts and users to understand data requirements, layouts, and look and feel of data reports and dashboards.
• Prepared Use cases and Look-and-Feel documents for Data Requirements, reviewed them with end users.
• Created transactional based data dashboards using actual orders and target orders, complete with Trend lines and table calculations to see the difference between each quarter.
• Created & Implemented MS SQL Database Components, Databases, Tables, views, Constraints, Stored procedures, Views and Functions.
• Generated T-SQL scripts for Data retrieval, Manipulation & Validation for various applications.
• Involved in Performance Optimization of Queries & Stored Procedures by analyzing Query Plans, blocking queries, Identifying missing indexes etc.
• Gathered end user requirements for data and worked with the DBAs to meet end Client specifications.
• Analyze the Business Requirements, Functional Specification, Use Cases and Configuration Spec Documents for Data related items.
• Wrote & debugged SQL scripts.
• Created end user and internal analytical reports from complex SQL queries.
• Created and implemented staging databases for data warehouses.
• Was responsible for data-related defects for the Defect Management Team. Presented defects and fixes to the Business, Project and Management Team.
• Wrote Complex SQL queries for Data manipulation, insertion, deletion and updates.
• Reviewed application Code to verify the accuracy, standards and optimizing the queries and minimizing the page upload times.
• Provide Weekly status report to Client & Provide Reports on Test execution of the team.
• Support issue resolution for emergency Production Data fixes.
• Consulted with key business users and subject matter experts to gather information about Reporting needs, objectives, functions, features, input and output requirements.
• Performed Quality Assurance /Unit Testing before the developed Data rules and Database Objects moved to Production system.
• Aided business users to solve operational data problems by recreating steps taken by them to locate the source of the issue.
• Develop and execute data test cases and test plans for Functional, Performance, Stress, and Regression testing needs.
• Created scripts for test cases. Test front-end user interfaces and make usability recommendations.
• Coordinated database maintenance activities with the off-shore Application Teams and scheduled necessary scrum calls and technical sessions.
• Reviewed and provided feedback on data-related project deliverables.
• Performed knowledge transfer to technical personnel for data-related items as necessary.
• Ensured delivery of bug free databases to the Production Applications and supported QA and UAT testing activities.

Confidential

ETL Developer

Roles & Responsibilities:

• Worked as Data Engineer to turn data into information, information into insight and insight into business decision.
• Designing and developing ETL processes using SQL Server Integration services, used for gathering and manipulating with data across different platforms and systems later used for building business reports.
• Worked on Data Migration from the Legacy systems into the SAP.
• Worked on the SAP Data Migration objects like the Master Data VENDOR, CUSTOMER, etc.
• Worked on Data Migration from the Legacy systems into the SAP.
• Interacted with Business analysts and End users to understand functional and technical requirements
• Installed and configuration of SAP BODS 4.0
• Installed the Information Platform Services and 4.0 in DEV, QA, PRODUCTION
• Defined Data Stores to allow Data Services to connect to the source or target database.
• Used ETL extraction, transformation and loading data from heterogeneous source systems.
• Strongly developed various Workflows and Data flows where the data is extracted from the sources including Oracle 11g, SQL Server 2008 then loaded into SAP ECC 6.0.
• Used BODS cleansing transformations for de-duplication, house-holding and address parsing.
• Used various transformations including Map Operation, Table Comparison, Row-Generation, Query History Generation, Key Generation, Pivot and Query.
• Used the SAP inbuilt AIO jobs for customer master.
• Scheduled, monitored and fixed the errors of the jobs.
• Used Business Objects Data Services interactive debugger to test the jobs and fixed the bugs.
• Applied aggregate awareness to speed up query time.
• Troubleshooting and performance tuning which reduced several jobs from several hours to less than one.
• Developed complex database objects like Stored Procedures, Functions, Packages, Triggers using SQL.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files.
• Involved in defining the source to target data mappings, business rules, business and data definitions. Optimize mappings to achieve faster load.
• Understood the End-to-end Data flow and data integration rules to implement logic.
• Daily activities include, PL/SQL anonymous blocks & Objects creation, integrating them with shell script, Generating Reports using SQL queries.
• Troubleshoot the minor glitches occurred while creating the application.
• Creating highly complicated SQL queries for various reporting requirements which runs daily, weekly, monthly, Quarterly, semi-annually and annually.
• Created SQL scripts to find data quality issues and identify keys, data anomalies, data validation issues.
• Assisted Developers in Data Modeling using Entity Relationship Diagrams.
• Assisted in the application development, debugging, configuration, and optimization from database perspective.
• Experience transferring files across different operating systems through tools such as WinSCP, SFTP.
• Provided feedback and technical guidance to Project Managers on issues of critical importance to achieving business objectives.
• Participated in daily SCRUM meetings and give the daily status report.