Summary

• Over 7 years of IT experience in the Analysis, Design, Development, Implementation and Testing Client/Server applications using Talend, Microsoft SQL Server 2005/2008/2008R2/2012, Oracle Client, Business Intelligence Suite and practical VBA programming. Practical experience in migrate huge volumes of data from legacy system.
• Extensive experience in Importing/Exporting Data from various data sources like CSV, Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.
• Experienced in Business intelligence tools like Talend and SQL Server Integration services SSIS , SQL Server Reporting Services SSRS as a Data Warehouse Developer.
• Specialty expertise with Talend most used components tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput, tHashOutput, tJava, tJavaFlex and many more
• Experience in creating SSIS Packages using Fuzzy Lookup, Derived Columns, Data Conversion, Condition Split, Aggregate, and Execute SQL Task, Web Services Task, Execute Package Task etc. to generate underlying data for the reports and to export cleansed data.
• Excellent T-SQL Developer skills including Stored Procedures, Indexes, Views, User Defined Functions, Triggers, Cursors and Distributed Transactions.
• Strong stored procedures experience in previously projects including debugging and optimization.
• Involved in large-scale financial data warehouse Financial Services, Insurance, Banking initial creation, gathered requirement and rules, prepared the comparison of data element between DW and source system, communicated with users weekly to identify rules and patterns, documentation.
• Experience in design, development support applications including troubleshooting, analysis, tuning, optimization, and ad hoc workarounds for production applications and reporting projects.
• Hands on experience in creating different types of Tabular, Matrix, Drill-Down, Cascaded parameterized, Chart report, Sub reports and Distributed Reports in multiple formats using SSRS.
• SQL Server OLAP database development including KPIs, Data mining, working with slowly changing dimensions Fixed, Changing and Historical .
• Experience in directly communicate with Users /Clients to understand the requirement and purpose of analysis. Involved in Installation, Configuration and Updates of Window Server, SQL, and backup and upgrade of DEV, QA, and PROD Server.

Skillset:

Microsoft SQL Server 2005/2008/2008R2/2012, SQL Server Management Studio SSMS , SQL Server Business Intelligence Development Studio BIDS , SQL Server Analysis Services SSAS , SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Oracle 9i/10g/11g, MySQL, DB2 9, C, C , Java Script, Data mining, Data Profiling, MS-Access, MS-Excel, MS-Excel VBA, T-SQL/PLSQL,.NET, XML, Visual Studio 2005/2008, Crystal Reports, SQL Profiler, ERWIN, MS Visio, SharePoint, Unit testing, Power pivot, Beyond compare, FTP, SSH.

Professional Summary

Confidential

ETL Developer / Analyst

• Used ETL methodologies and best practices to create Talend ETL jobs
• Extracted data from flat files/ databases applied business logic to load them in the staging database as well as flat files.
• Developed mappings /Transformation/Joblets in Talend 5.4.
• Designed ETL Jobs/Packages using Talend Integration Suite TIS
• Worked on different data sources such as Oracle, Netezza, MS SQL, Flat files etc
• Created complex mappings in Talend 5.0 using tHash, tDenormalize, tMap, tUniqueRow. tPivotToColumnsDelimited As well as custom component such as tUnpivotRow
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats into a Database table to record job history
• Created Talend Mappings to populate the data into dimensions and fact tables
• Implemented new users, projects, tasks within multiple different environments of TAC Dev,Test,Prod,DR
• Worked with clients and created specific MRS documents to ensure mapping was to their specification.
• Worked with third party vendors on specific requirements needed for new feeds.
• Created and managed Source to Target mapping documents for required jobs.
• Ensured jobs, projects and MRS documents were up to date on the SVN within different environments.
• Was involved in the creation and fixing of jobs for four different teams. One of which was the release team for Sony.
• Worked on heterogeneous data sources such as Oracle, SQL Server 2008
• Created physical database objects from data model to physical database like tables, indexes, views, and triggers. Also created DDL files to be deployed by production DBAs.
• Developed Talend Jobs for ETL to perform data cleansing, standardizing, and sourcing from DB2 database and load to target for initial load and for Change Data Capture CDC data load including absentee processing.

Environment:

Talend Integration Services 5.0 , Netezza DB, MS SQL Server 2008,T-SQL, Unix, Linux, Wiki, SVN, Talend Administrative Console TAC , Java, Oracle,DB2 9

Confidential

Business Intelligence Developer

Responsibilities:

• Participated and contributed in Requirement gathering for Data warehousing, data migration, and data integration projects.
• Review the document to create Enterprise data definitions and map new data structures to the logical data model.
• Conducts the gap analysis of source to target mappings and data definitions.
• Used ETL methodologies and best practices to create Talend ETL jobs.
• Extracted data from flat files/legacy databases applied business logic to load them in the staging database.
• Developed mappings /Transformation/Joblets in Talend 4.2.
• Designed ETL Jobs/Packages using Talend Integration Suite TIS
• Implemented population of slowly changing dimensions to maintain current information and history information in warehouse tables with change data capture CDC .
• Worked on different data sources such as Oracle, SQL Server 2008, Salesforce, Flat files etc.
• Created complex mappings in Talend 4.2 using tMap, tJoin, tReplicate, tParallelize, tJava, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, etc.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats.
• Created Talend Mappings to populate the data into dimensions and fact tables.
• Created Talend ETL job to receive attachment files from pop e-mail using tPop, tFileList, tFileInputMail and then loaded data from attachments into database and archived the files.
• Design and Implemented ETL for data load from heterogeneous Sources to SQL Server and Oracle as target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
• Performing Database Administrator DBA jobs like creation and design of Tables, creating Stored Procedures using T-SQL, SSIS Packages.

Environment:

Talend Integration Services TIS 4.2 SQL Server 2008 T-SQL, Oracle 10g Salesforce Wiki Windows 2003 Server

Confidential

Data Analyst/ETL Developer

Responsibilities:

• Design and Implement ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions SCD Type1, Type 2, Type 3 to capture the changes.
• Designing, developing and deploying end-to-end Data Integration solution.
• Develop the ETL mappings for XML, .CSV, .TXT sources and also loading the data from these sources into relational tables with Talend ETL. Developing complex ETL mappings for Staging, Operational Data Source ODS , Data warehouse and Data marts load.
• Provide detailed business and data requirements including complex data mappings.
• Conducted Data/Requirements gathering sessions and created managed Source to Target mapping documents for all Facts and Dimension tables. Scheduling the ETL mappings on daily, weekly, monthly and yearly basis.
• Actively participated in gathering business requirements and system specification from system users.
• Analyzed requirements, designed, maintained and updated data models.
• Analyzed existing data management procedures in practice and suggested ways to automate the process and improve the existing system.
• Develop test plans, test cases, procedures, and documents given business requirements and design documents.
• Developed stored procedures to pull data from the distributed systems.
• Tuned SQL queries using quest central tools.
• Developed and implemented complex data models and logical database designs and defined database requirements and designed data model.
• Extensively used SQL Loader to load data from flat files to the database and validated data with PL/SQL procedures.
• Developed back-end PL/SQL packages, built UNIX shell scripts for data migration and batch processing.
• Tuned complex stored procedures for faster execution and developed database structures according to requirements.
• Integrated the mailing system to alert various group on the status of data pulls and data processing.
• Developed and implemented dozens of automated batch processing jobs in numerous development, test and production environments.
• Involved in importing production data to work environment using TOAD.

Environment:

Oracle 11g, UNIX Shell Scripts, PL/SQL, Toad, PL/SQL Developer, SQL Optimizer.

Confidential

QA Test Engineer

American Red Cross ARC Armed Forces Emergency Services AFES helps military members and their families by providing emergency services in times of need. Some examples include around-the-world communication to service men and women, financial assistance, etc. A number of service centers or chapters that are located throughout the world provide these services

Responsibilities:

• Developed test strategy document and test cases based on Software Requirement
• Performed functional testing for web based user authentication GUI and document
• Conduct Regression testing and system interface testing for each release.
• Execute test plan and format results and communicate to user.
• Analyzed the final Requirements Traceability Matrix RTM for discrepancies and
• Queried databases with SQL to obtain sample data.
• Participated in team meetings, peer reviews, defect reviews and Test Readiness
• Defining defects and carried out test reports using HPQC as Defect tracking system
• Documented the Problem Reports PRs for all the bugs detected and tracked the bug
• Managed other tests including User Acceptance Testing UAT .

Environment:

QTP, Oracle, UNIX, Windows, TestDirector, DB2, SQL Server, MS Office, .NET.

Confidential

Junior QA Analyst

Responsibilities:

• Developed and executed test cases for Booking and Print Control.
• Developed Requirement Tractability Matrix RTM from Use Cases
• Collected defect data and generated test reports using Test Director.
• Performed variety of testing's starting from Smoke test, Acceptance testing, System
• Organized Walkthroughs and Inspections to review the status of the application.
• Performed Positive, Negative and Boundary testing around the application.
• Performed Regression testing over different builds and defects were reported
• Performed Database Validation by using SQL queries in SQL Navigator.
• Participated in User Acceptance Testing UAT .
• Designed the automation framework and test scripts of the application using

Environment:

Test Director, XML, Oracle 9i, TOAD, Windows, UNIX, MS Office, User acceptance testing