SUMMARY

• Full System Development Life Cycle (SDLC) experience including requirement gathering, analysis, design, development, testing, and implementation of various medium and large scale client/server applications in a structured development environment.
• Understanding in database and data warehousing concepts (OLTP & OLAP).
• Involved in designing numerous DB Objects like tables, constraints (primary key, foreign key, and unique key) and indexes.
• Experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency.
• Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation.
• Experience in Extraction, Transformation and Loading (ETL) of data flows using SSIS with complex integration of Excel, XML, CSV, text, flat file sources, MS Access, SQL Server, Oracle and IBM mainframe DB2.
• Extensive experience in Microsoft stacks of BI solutions - SSRS, SSIS with MS SQL 2012/2008R2/2008/2005 - using integration services (SSIS) for ETL, worked on data cleansing techniques using look ups, conditional split, merge and derived columns.
• Experience in designing reports using table filters, single value parameters, multi-value, dependent and cascading parameters.
• Experience in configure and maintain Report Manager and Report Server for SSRS, deployed and scheduled the reports in Report Manager.
• Created documentation, ER Diagrams using MS Visio and Erwin for ER modeling

TECHNICAL SKILLS

Databases: SQL Server 2012, 2008 R2,2005, Oracle, DB2, MS Access

Programming Languages: T-SQL, PL/SQL, C#

Operating Systems: Various Windows and UNIX environments

Version Control: Team Foundation Server (TFS), CVS

BI & ETL Tools: SQL Server Management Studio (SSMS), MS Visual Studio 2012/2008/2005 , SQL Server Integration Services (SSIS) and SQL server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Profiler

Development Methodology: Agile/SCRUM, Waterfall

Job Scheduler: SQL Server Agent

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Develop ETL Solution to consolidate the loan customer applications such as Flat Files, Excel, XML, and SQL Server databases from multiple sources into one Loan Application Database, and provide Business intelligence analytical reports to support the Loan Business process for National Mortgage Company.
• Analyze source system data to determine the data model and ETL solution that will meet business requirements.
• Create complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and ForEach Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Develop and create new database objects including tables, views, indexes, triggers, stored procedures and functions.
• Involve in database management, performance measurement and performance tuning for new databases and existing databases.
• Design and developed SSRS reports, sub reports, data driven subscriptions, drill down reports and drill through reports using various features like Charts, graphs, filters etc.
• Write Stored Procedures to populate various dimensional tables and fact tables for the Data Warehouse.
• Develop Multi-dimensional Objects (Cubes, Dimensions) usingSQLServerAnalysis Services (SSAS).
• Participate in Quality processes such as design reviews, peer code reviews, version control.
• Knowledge in C# script component in SSIS packages.

Confidential, Plano, TX

SQL Server Developer

Responsibilities:

• Provided ETL Solution for the Merchant Servicing Systems, extracted payment transactions, merchant and Store Sales information from the Payment Core Systems in various format such as flat files, SQL server and Oracle.
• Formulated and documented the physical ETL process design based on business requirements and system specifications, including source to target mappings, transformations, lookups, aggregations and expressions.
• Transferred Data to data warehouse and exported files in various formats based on requirements using SSIS Packages.
• Wrote and executed complex T-SQLqueries usingSQLManagement Studio for back end data validation testing.
• Coordinated with DBA in creating and managing Tables, Indexes, Triggers, DB links and Privileges.
• Managed business issues on connectivity, permissions, data validation & worked with business analysts for report generation.
• Extensively work in designing & deploying SSIS packages for transferring data from heterogeneous data to and from SQL Server.
• Analyzed Queries and boost the performance necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.

Confidential, Plano, TX

SQL Server SSIS/SSRS ETL Developer

Responsibilities:

• Worked without a Business analyst and developed a BRD (Business Requirements Document) to automate the ETL process for Confidential Corporation.
• Reviewed and analysed data from multiple internal and external sources to interpret data that was not well defined or documented and developed the solution based on findings.
• Developed an ETL solution in Visual Studio using SSIS which extracted and loaded Customer, Sale Details, Product Inventory information from Flat Files, Excel and SQL Server databases.
• Transformed data using Row Count, Conditional Split, Data Conversion and lookup transformations
• Installed and configured SQL Server 2008 R2 on Windows server 2008.
• Involved in creation of various dashboard used for reporting to the end user.
• Worked on SSRS reports to report the Daily, Weekly and Monthly Statistics of various processes.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Generated the drilldown, drill through and linked reports using SSRS.

Confidential, Dallas, TX

SQLDeveloper

Responsibilities:

• Supported Credit Card Systems for Confidential and extracted credit card transactions, Customer and demographic input sources from multiple platforms such as DB2, Oracle and SQL Server databases.
• Transferred Data to data warehouse and exported files in various formats based on requirements using SSIS Packages.
• Created various Stored Procedures to validate the data from the source and update/insert the records into target tables.
• Involved in Technical decisions for Functional requirements, Data Mapping, Data Directory. Interaction with Business Analysts, Client team, Development team.
• Supported DBA in activities related to database and log backups, restoration, backup strategies and scheduling backups.
• Created technical specifications, test plans and test data to support ETL processes.
• Developed test cases and contribute to deliverables for additional levels of testing and support test execution.