SUMMARY

• Highly Motivated and ambitious Database Developer with SQL - Server Developer/SSIS/SSRS/BI Developer/T-SQL with 7 years of experience.
• Further experience in software design and development, testing, data conversion and system support in various domains like Online Retail, HealthCare and Banking.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, DTS, SSIS, SSRS

Database: MS SQL Server 2017, 2016, 2012, ORACLE, AZURE.

Language: HTML, TSQL, MYSQL,PLSQL, UNIX

Operating System: Windows, Unix

Tools: SSMS, Microsoft Office, SVN, EXCEL, Power BI, QTP, Azure TFS, TFS, Octopus, Team City, Share point, Tidal, Microsoft Service Now, Active Batch, Zappysys

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential, Tulsa, OK

Responsibilities:

• Gathering Business requirements.
• Worked with the Third party tool Zappysys for ETL purpose.
• Created ETL/SSIS packages to extract data from various sources like Flat files, oracle to SQL Server systems using different SSIS components and used dynamic configuration files and variables for production deployment.
• Created ETL package using third party tool zappysys to get data from different applications and loaded into databases.
• Created ETL package using third party tool zappysys load into different Applications from databases.
• Used Zappysys tool to convert data into XML/JSON format.
• Used OData query to get data from sql server as json format.
• Used Active Batch for scheduling jobs.
• Created Technical documents.
• Actively involved in debugging in failed SSIS packages.
• Ability to work independently or as part of a team to accomplish critical business objectives as well as good decision making skill under high pressure complex scenarios.
• Understanding requirements, fixing the issues, update Root Cause and Resolution to issue tracking tool.

Environment: s: - SSIS, Zappysys, Active Batch, SQL Server, Share point.

BI Developer

Confidential, Louisville, KY

Responsibilities:-

• Created SSIS Package using BIML script and Updated existing BIML script.
• Participated on AZURE SQL Database Workshop provided by Microsoft.
• Supported production issues for DW Reporting and ETL jobs.
• Created SSRS report and updated on existing report.
• Actively involved in debugging failed SSIS Jobs.
• Created ETL/SSIS packages to extract data from various sources like Excel, Flat files, CSV files to SQL Server systems using different SSIS components and used dynamic configuration files and variables for production deployment.
• Expertise in creating/modifying Tables, Views, Store Proc, Functions, Indexes and Triggers and in depth knowledge in query optimization and performance tuning
• Processed entree level coding like logging, Error handling by using Event Handler.
• Ability to work independently or as part of a team to accomplish critical business objectives as well as good decision making skill under high pressure complex scenarios.
• Understanding requirements, fixing the issues, update Root Cause and Resolution to issue tracking tool.
• Used Power BI for the creation of dashboards and Reports for the tracking of SQL Jobs activities for our Data warehouse.

Environment: s:- : SSIS, SSRS, PowerBI, BIML Script, MS Office, Azure TFS, MS Outlook, SQL Server, Excel, Share point, SQL prompt.

BI Developer

Confidential, Dayton, OH

Responsibilities:

• Experience in Inbuilt tool of BCP (Bulk copy program) tool for Straight move (No transformation) from Source to Target.
• Involved in Data migration from Teradata to SQL server using BCP and SSIS.
• Actively involved with the Business to get more information about requirements.
• Experienced of work with Different teams.
• Involved in Extracting, Transforming and Loading (ETL) operations in SSIS and worked on Containers, Tasks and developed SSIS packages to load data from different Heterogeneous Data Sources to different Destinations.
• Experience in performing Full Load, Incremental Load with various Data Flow Transformations and Control Flow tasks.
• Experience in scheduling jobs using SQL Server Agent and Tidal.
• Involved in Deploying, Managing and Troubleshooting SSIS packages and update existing SSIS package.
• Used Microsoft Team Foundation Server (TFS) to perform agile tasks in creating new feature, stories.
• Used SVN to check in code in central repository.
• Strong experience in writing complex T-SQL queries which involves multiple Tables using Joins, Views, Stored Procedures, index and User Defined Functions.
• Experience in improve SQL scripts performance.
• Experience in Health check of Database tables.
• Experience of octopus and Team city for automation deployment in different Environment.
• Created Tables, views (active and historical), Indexes, Store procedures, functions and TSQL scripts for implementing business logic.
• Involved in Peer review testing.
• Created and maintained databases, tables, stored procedures, indexes, and business rules using T-SQL.
• Established Joins and created Clustered/Non-clustered Indexes wherever necessary.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Involved in deploying the changes in to Integration, and Production environments.

Environment: SSIS, MS Office, Tidal, Octopus, Team city, TFS, MS Outlook, SQL Server, Excel, Share point, BCP(Bulk Copy program)

BI Developer

Confidential, Dallas, TX

Responsibilities:

• Created numerous simple to complex queries for Stored Procedures, Triggers, Functions, View for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• Migrate and Convert customer legacy database using SQL Server.
• Designed and developed SSIS Packages to import and export data from MS Excel, Flat file, Oracle to MS SQL Server by using SSIS services.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Data Flow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Worked with Metadata Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Experienced in working with multiple data sources like, SQL server, Oracle, Excel files, Flat files.
• Developed various types of complex reports like Drill Down, Drill through, Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Involved in Normalization and Demoralization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: : MS SQL Server 2012, MS Access, SSIS, SSRS, T-SQL, Microsoft outlook, MS Excel, Windows 7, SVN

BI Developer

Confidential, Basking Ridge, NJ

Responsibilities:

• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• Created several packages in SSIS.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Scheduling the SSIS package and Jobs.
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and Oracle Database.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Generated custom and parameterized reports using SSRS.
• Involved in developing SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Used various transformation tasks to create ETL packages for data conversion.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Performed Query optimization & Performance Tuning.
• Optimized queries using SQL Profiler and Database engine tuning advisor.

Environment: SQL Server 2012, SQL Server Integration Services (SSIS), SSRS, SQL Server Data Tools, Windows 7, Microsoft Office SharePoint, Excel.

SQL Developer / Data Analyst

Confidential, Mountain View, CA

Responsibilities:

• Involve in gathering business requirement and test development stage from the beginning worked closely with Test owner, Test Developer, Data source contact.
• Experience in writing SQL Queries, T-SQL, Stored Procedures, Views, Functions, Indexes, and database Triggers.
• Defined Check constraints, Business Rules, Indexes, and Views as per requirements.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Developing SSIS packages for extracting the data from Staging Database, perform the QC Rule Check and loading into the National Property Database.
• Performance tuning of complex SQL queries and Stored Procedures to increase the performance and worked on exception handling.
• Identify data source and request access to data source as per the intakes requirements.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, Web Services Task etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated.

Environment: SQL Server 2012, Oracle, T-SQL, SSIS, Oracle, Windows.

Data Analyst

Confidential, Birmingham, AL

Responsibilities:

• Conducted JRD sessions with users and business clients to gather specific requirements and expectations and implement effective Data Modelling and ETL design.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Created database objects like Stored Procedures, UDFs, Triggers, Indexes and Views using T-SQL in both OLTP and Relational data warehouse in support of ETL.
• Performed Index analysis on tables and came up with more efficient solutions to use between different kind of indexes such as Clustered, Non-Clustered and Covering Indexes, filtered indexes.
• Created database objects like Stored Procedures, UDFs, Triggers, Indexes and Views using T-SQL in both OLTP and Relational data warehouse in support of ETL.
• Created views as required by front end developer for easier implementation on web pages, and wrote instead of triggers on those views to provide efficient data manipulation
• Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.
• Created complex SSIS packages to pull data from Oracle, Excel, flat files to SQL server.
• Implemented the Master Child Package Model for easier maintenance and better performance of the ETL strategy.
• Managed Package configurations for SSIS Packages in both XML files and SQL Server Tables.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.

Environment: SQL, HP ALM, SQL Server, SSIS, TFS, XML, Flat Files, UNIX, Share point.

Data Analyst

Confidential, San Francisco, CA

Responsibilities:

• Designed data and source-to-target mapping work on the BDW data warehouse.
• Checking and validating data in the Mapping document running the queries on DB2.
• Documented and maintained RTM (Requirement Traceability Matrix) to ensure that all requirements are traceable from top to bottom, hence provide a basis for test plan.
• Interacted with users for verifying user requirements, managing change control process, updating existing documentation.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Identified the source and target tables. Developed mapping document using MS excel.
• Determined the natural keys for the target tables.
• Designed outgoing file format (fixed or delimited) and field mapping for that files. Flat file conversion from the data warehouse scenario.
• Provided the required transformation logic using oracle and DB2 queries.
• Organized and conducted cross-functional meetings to ensure linearity of the phase approach.
• Collaborated with a team of Business Analysts to ascertain capture of all requirements.
• Executed SQL queries, PL/SQL stored procedures, triggers on back end as a part of data analysis and data validation
• Worked closely with the data architect to resolve the referential integrity problems.
• Validated the data during unit testing in the MO region before sending it for system testing.

Environment: Windows XP, SQL developer, Oracle, MS Office, PL/SQL