SUMMARY

• Over EIGHT year’s professional experience in Designing, Developing and Maintaining with SQL Server, TERADATA, Oracle on both OLTP and OLAP Systems.
• Experienced and fully participated in Agile Systems development life cycle in multiple projects.
• Skilled in MS SQL Server Business Intelligence tools such as SSMS, SSIS, SSRS, SSAS, Data Quality Application, strong MDX query skill etc.
• Hands on experience in setting up configuration files, logging, email alert task, parameterize source code and server environment, error handling for SSIS packages and SSAS cube.
• Fully participated in QA, Production database deployment and maintenance, includes composing technical release plan, code stage with RM team, DDL with DBA, DML, SSIS package deployment and emergency issue handling, bug fixing with Production Control team.
• Skilled in TERADATA Advanced query tools, Fast - Export utilities, familiar with power shell scripts for extract purpose, flat file transformation and management.
• Expertise and experience in T-SQL query, including Normalization, De-normalization, Stored Procedures, UDF, Constraints, Querying, Joins, Keys, Indexes, Data import/export, Triggers, Cursors, Pivot and Un-Pivot.
• Skilled in Query Optimization and Performance Tuning. Thorough knowledge of SQL Server including indexing, synonyms, service broker, Change Data Capture, Change Data Tracking, CLR integration, partitioning, replication, and compression.
• Experienced with object-oriented language such as C#, familiar with VB.Net, ASP.Net, VBA programming, LINQ query, Python scripting, UNIX Shell Scripting and etc.
• Familiar with all different types of data sources such as: XML, CSV, Oracle 10g, 11i, SQL Server database, spreadsheet, Access etc. and able to consume them and transform.
• Expert in Business Intelligence reports such as: SQL Server Reporting Service (SSRS) report, Tableau report, SAP dashboard, and various kind of Ad-hoc report
• Skilled in Business Objects’ Data Integrator BODS tools, Cognos software, Informatica, Tableau software, have experience with DB2 and Oracle, PL-SQL, and database administration work.
• Have experience in working with off shore team. Able to work independently. Highly motivated, committed and a natural team player with good communication skills and interpersonal skills coupled with the right ability to get things done.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Program analyst-SQL ETL Developer

Responsibilities:

• Analyzed data model’s feasibility, expected transactional performance from technical perspective by considering its fault tolerance, initial data loading time, refresh frequency, table & views dependency and etc.
• Translated business rules into mapping documents in order to manipulate data transformation from source to extract, de-duplication, data normalization and de-normalization.
• Scripted database objects: tables, views, triggers, keys, constrains, indexes and functions, extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables for stored procedures.
• Created SSIS packages using Data Conversion, Derived Column, Conditional Split, Lookup, Sort, Merge transformations and etc, within Data flow task, Execute SQL task, Script tasks, send email task, sequence container and etc.
• Wrote stored procedures to extract reporting’s transactional data, facts and dimensions, based on various business documents, clinical rules, SAS code, T-SQL code and etc.
• Developed multiple Web services using C# and able to auto generate complex formatted PDF form based on patients’ health records, providers’ data entry and clinical results.
• Improved and utilized rule engines, to analyze multiple measures in order to generate health alerts for each individual on Mango DB platform.
• Worked closely with Testing Team, successfully managed and resolved backend and Web services issues by utilizing JIRA.
• Deployed QA, Production databases includes composing technical release plan, set up release meeting, code stage with RM team, DDL with DBA, DML, SSIS package deployment and emergency issue handling, bug fixing with Production Control team.
• Participated in different releases’ maintenance, documented share point trackers for each different release deployment from DEV to TEST to QA to PROD
• Highly motivated to be able to reach each milestone within tight sprint schedules and under heavy pressures.

Environment: SQL Server 2012, Visual Studio 2008, TERADATA Advanced query tools, SSIS, Windows 7.

Confidential, Teaneck, NJ

Program analyst-SQL ETL Developer

Responsibilities:

• Participated in data warehouse designing from scratch. Worked closely with BA to gather business requirement, business rules, reporting requirement, provided technical advice for data modeling.
• Created types of SSIS packages for three major purposes: Data warehouse daily refresh, Data Hygiene and Database maintenance. Covering advanced task scenarios, parallelism, error handling, and scheduling.
• Finished data integration and data quality control for data warehouse using Business Objects' Data Integrator BODS tools, used Python scripting for quality control purpose.
• Consumed various types of data source (Web service) including: FTP remote flat file, WEBTREND, Google Analytics, REST Web service API, CSV, XML, OLAP, OLTP databases, Excel etc.
• Generated SSAS cubes by utilizing MDX, T-SQL query. (Used as reports’ data source to improve real time performance) and scheduled daily refresh, monitored its everyday working flow, transaction log.
• Created and published to clients with the following types of reports: SQL Server Reporting Service report, Tableau report, SAP dashboard, and various kind of Ad-hoc report
• Provided data hygiene solution in order to de-duplicate data, and improve data accuracy by: programming T-SQL function, stored procedure, combined with SQL Server Data Quality Client application, and third party service: Melissa dataset.
• Replaced most of the formatted Ad-hoc reports, by publishing similar Tableau report to internal and external servers and automate the process, in order to minimize the future’s manual work.
• Introduced pivot table, VBA programming attached query string to excel, to automate the spreadsheet, Access report using Tableau software, Visual FoxPro for data access.
• Finished professional reporting layout design, worked closely with .Net team for report publishing, Web service test and deployment.

Environment: SQL Server 2008/2012, Visual Studio 2008/2012, SSIS, SSAS, SSRS, Visio, Tableau Software, SAP Dashboard, Data Quality Client, MS Excel, etc.

Confidential, New York, NY

Program analyst-SQL ETL Developer

Responsibilities:

• Created trading transaction reports by retrieving data via Stored Procedures that accept parameters depending upon the operator’s requirements.
• Created Tabular reports, Parameterized Reports, Cascading Parameterized, Cached Report, Drill-down reports, Drill-through reports and Sub Reports for the Loan System.
• Extensive use of Prompts for generating dynamic and flexible reports and performance tuning of various Micro Strategy reports.
• Defined requirements, design, develop, test, implement and maintain reports using SSRS.
• Performed a T-SQL script to load initial data into various dimensions and fact tables using SSMS.
• Created SSIS packages to update and insert historical data into de-normalized tables.
• Using control flow elements like for each loop and sequence container, execute SQL task, execute process task, execute package task and script task, file system task send mail task in ETL.
• Created SSIS packages, using Data Conversion, Derived Column, Conditional Split, Copy column Transformation and etc. to consume various types of data sources.
• Designed efficient triggers, cursors, tables, views, indexing and other SQL joins and statements for applications.
• Provided database management assistance and analyst related to performance measurement.
• Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
• Design User Acceptance Test (UAT) and parallel production test plan, and implement testing for internal system release

Environment: SQL Server 2005\2008, Visual Studio, OLAP, T-SQL, Windows XP, SSIS, SSAS, SSRS, MS Access, MS Excel.

Confidential, Murray Hill, NJ

MS SQL ETL Developer

Responsibilities:

• Translated requirements into ETL design specifications.
• High level design of ETL package in SQL server 2005 for integrating data from heterogeneous sources.
• Created the package to import data from multiple sources to the staging environment using SSIS.
• Created the package to export data from the staging environment to the Data warehouse using SSIS.
• Performed data cleansing and massaging using various transformation components in SSIS and also cleared duplicate data using SSIS dataflow components.
• Implemented complex ETL processes involving diverse data sources and transformations.
• Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Configured the package to send email messages if tasks in the package workflow succeed or fail, or send messages in response to an event that the package raises at run time.
• Handling the exceptions with the help of SSIS by transferring the data into separate flat file or error table.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created variables and configuration files to make the package more dynamic and schedule jobs to run automatically using SQL server agent.
• Deployed the packages on staging and production environment by copying the deployment folder into a target machine and proceeding to run the package installation wizard.
• Expert in Technical design and documentation.
• Extensively used variables, package configurations, logging, exceptions handling for each ETL process.

Environment: SQL Server 2005\2008, Visual Studio, OLAP, PL\SQL, Windows XP, Windows VISTA, SSIS, SSRS.

Confidential, Garden City, NY

MS SQL Server Developer / SSRS/SSIS

Responsibilities:

• Migrated databases from MS SQL server 2000 to MS SQL server 2005 using SSIS with Transfer Database task, back up and restoration technique.
• Designed ETL process using SSIS and extracted data from flat files, excel files and SQL server database.
• Extracted structured and unstructured data from source systems, transform it to fit business performance management needs, and load it into data mart.
• Created scripts to migrate SQL server objects from one environment to another.
• Created database objects like tables, views and indexes, extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Generated parameterized, drill down, drill through and cross-tab reports in SSRS 2005 for analysis.
• Designed, developed and deployed monthly reports based on the revenue and sales to the designated Managers and Clients in MS SQL Server environment using SSRS-2005.
• Gauged the effectiveness and efficiency of existing reporting systems.
• Developed and implemented strategies for improving and further leveraging these reports in order to transfer/convert existing reports to SQL Server Reporting Services.
• Created ad-hoc reports using Report Builder 2.0.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Applied Security services to Database Server that affects Reporting services. Managed role-based security to reports and reporting resources.

Environment: Windows server XP, MS SQL Server 2000/2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, T-SQL, OLAP, OLTP, Excel, Acrobat Reader, Report Builder 2.0.

Confidential 

MS SQL Server Developer

Responsibilities:

• Worked as an entry-level developer on databases MS SQL Server 2000, Involved in migration between SQL server 7 and SQL server 2000 using Upgrade Advisor.
• Tuned SQL Statements, Store Procedures by exam its execution plan, Performed Index analysis for major tables and came up with more efficient solutions, applied Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Scripted multiple complex stored procedures for the Web service team, simplified existed stored procedures by utilizing temp tables and sub queries.

Environment: MS SQL Server 7/2000, MS SharePoint, MS Access, MS Excel.