SUMMARY

• Around 5 Years of experience as SQL Server BI developer (SSIS/SSRS) including writing T - SQL Programming.
• Experience in migrating from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008 R2.
• Experience in Objects creation such as Tables and Views, Table Normalization, User Defined functions, Indexes, Stored Procedures, coding, Correlated sub queries, Cursors and Triggers.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008.
• Created the Different types of reports such as Linked, Sub report, Cascading report, Drill down and drill through Reports.
• Proficient in using global variables, expressions and functions for the reports.
• Generated reports using SSRS that could be used to send information to diverse group of users.
• Create and maintain SSIS packages to extract transform and load data in to SQL Server.
• Experience in SSIS tools like Import Export wizard, Package installation, and SSIS Package Designer.
• Experience in the ETL processes involving migration and sync process between two databases.
• Experience in creating configuration files to deploy the SSIS package across all environments.
• Worked closely with DBA to perform Database back up, Restore and Replication.
• Worked on different SSIS Tasks of data flow, control flow.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of theETLusing SQL Server Integration Services.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert.
• Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience in SQL Server SSIS (Integration Service) package design, constructing, and deployment.
• Extensively created dashboards against using SSRS.
• Created OLAP Cubes based on the data stored in Facts and Dimensions.
• Great Knowledge in Dimensional Modeling, Star Schema/Snowflake Schemas, ODS.
• Experience in Performance Optimization
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle, DB2 etc.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

RDBMS/DBMS: SQL Server 2005/2008/2008 R2/2012/2014

BI Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Studio, Visual studio 2008, T-SQL, DTS.

Languages: T-SQL.

Operating Systems: Windows 2008/2003/2000/ NT 4.0, Window XP/VISTA/7

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati OH

Database Developer

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• DesignedSSISPackages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server.
• Used SQL Server Agent for scheduling jobs and alerts.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• Worked to investigate the data loss with multiple environment.
• Created the test data to perform the unit testing.
• Performed Unit Testing.
• Wrote complex stored procedures to maintain the dataflow to multiple system and Satisfied the data format, and transformation needed to transform the data.
• Used VSTS for the version control.
• Worked strictly under the agile framework.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and stored procedures.

Confidential, Cincinnati, OH

SQL/SSIS Developer

Responsibilities:

• Created the DTS package through ETL process to vendors in which records were extracted from flat file and excel sources and loaded daily to the server. Update the statistics information for both the old and new servers.
• Involved in complete SSIS life-cycle in creating in SSIS packages, building, deploying and executing the package in both the environments (Staging and Production).
• Worked on different task and transformations such as Execute SQL Task, Execute Package Task, Zip Task, Conditional Split, Script Components, FTP, Merge and Lookup while loading the data into the destination.
• Created new database objects like Procedures, Functions, Triggers, Indexes and views using T-SQL in SQL Server 2012.
• Created and modified tables, stored procedures, various indexes, triggers and check constraints.
• Designed SQL SSIS packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server for further data analysis and reporting by using multiple transformations provided by SSIS such Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Created various Ad-hoc SQL queries for customer reports, execute management reports and report types like tabular, matrix, sub reports etc.
• Extensively used ALM to track the tickets.
• Wrote complex query in MySQL.
• Conducted knowledge sharing session with the new hire.
• Documented all the phases of the project as per the requirement.
• Provided back end support for the Functional testing and performance testing.

Confidential, Lewisville, TX

SQL/SSIS Developer

Responsibilities:

• Imported the data from Teradata into the SQL Server using the SSIS.
• Imported the data from Oracle into the SQL Server using SSIS.
• Automated the testing logic and translated it into the SSIS Package.
• Translated the data validation logic into SSIS package.
• Scheduled the package to run on timely manner; weekly, bi-weekly and monthly using the Control M.
• Tracked the defects using the ALM.
• Provided database solution and ensure quality assurance and timely delivery of the data.
• Investigated, troubleshoot and corrected data to ensure the data integrity.
• Managed the SQL Server enterprise environment.
• Translated the stakeholder’s requirement into the database design.
• Promoted a constructive, positive team environment and maintains a spirit of openness, information sharing inquisitiveness, problem-solving and support the for the common goals of the team.
• Analyzed source system for loading into the SQL Server and communicated findings and make recommendations back to the team.
• Analyzed database in response to new functionality and summarize finding and implement recommendations.
• Performed impact analysis to assess impact of source changes
• Coordinated with data quality analysts to understand data requirements.
• Excellent organizational skills and attention to detail, and excellent data analytic skills.
• Ability to allocate time efficiently; handle multiple demands and competing priorities.
• Strong time management skills, fast learner, self motivated, and comfortable taking initiative and handling multiple projects simultaneously.
• Ability to problem solve by analyzing and challenging conventional thought processes and using experience and/or intuition to create pragmatic solutions

Confidential, Dallas, TX

T-SQL / SSIS Sampling Developer

Responsibilities:

• Worked independently to uncover and resolve issues associated with finding data that can be used by Compliance Tester to monitor operational compliance.
• Served as a consultant to test Designer to ensure appropriate data filters are applied based on the business / product needs.
• Analyzed the SSIS package to see whether its meets the criteria proposed by the test owner.
• Updated SSIS package to meet the criteria proposed from the test owner.
• Verified the requirement of the test owner and updated it to meet the Compliance Control Regulation.
• Created the optimized SQL query to pull the sample from database using RAND () and NEW ID () function.
• Created the SSIS Package the using different task and transformation in the control flow and data flow task of SSIS.
• Developed, Deployed and monitored the SSIS Packages.
• Created SSIS package using SSIS Designer to export data from the heterogeneous data from OLED DB Source, Excel Spreadsheet to the SQL Server 2014.
• Have an exposer Informatica Developer Tool IDQ.
• Have some exposer to IDQ rules, source profile and target table.
• Created and updated CTEs, Stored Procedures, Views to retrieve the data from the database.
• Provided analytical support in EIT activities related to multiple Compliance Control Function.
• Analyzed the pre-existing T-SQL query to see if it meets the requirement from the test owner.
• Updated the T-SQL query to meet the criteria from test owner.
• Gathered and organized data in order to track, report and monitor effectiveness of controls and tracking, monitoring and escalation of risk related to management.
• Investigates data attributes within various operation and the reporting database. Builds logics for automated data extraction and validation for EIT testing.
• Acted as subject matter expert on datamining, code development, quantitative tools and automated reporting.
• Worked within the policies and standards regarding sampling methodologies, thoroughly documented operating procedures for sampling execution.

Confidential, Willow Park, TX

SQL SSIS / Production Support

Responsibilities:

• Participated in the meeting to take the business requirement, and organized the meeting to convey the thought and the business flow and the requirement.
• Created the database for the new client.
• Created the complex stored procedure that inserts update the system in the single shot.
• Created the triggers, views, table and set up the replication plan for the database.
• Wrote the query to back up the production, QA database and implemented it in the SQL job to run it every night.
• Created complex ETL Packages using to extract data from staging tables to partitioned table with the incremental load.
• Created SSIS Reusable package to extract the data from multi formatted flat file, excel, XML files into UL Database and DB2 Billing system.
• Had profiling, applying and mapping to move data from source to target system using Informatica IDQ.
• Worked Closely with the manager to deploy the package across the environment.
• Developed the SSRS report and prepared the dashboard to show the performance of each department based upon the quantity of task they accomplished.
• Prepared the automated email system to send mail to user, using an SQL Server SP-Mail Stored proc.
• Developed the Cascading SSRS Report to with the multiple parameters.
• Created the Stored procedure to help the C# Developer in the work.
• Created the Stored procedure that loads the data directly from the Excel file.
• Created the Rounding function for the payroll department, to display the total time worked in to the hundred.
• Created the views that retrieves the data from multiple tables. It helped the C# developer to implement it in the UI.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.
• Participated in the creating new environment for the new client.
• Functional testing the application and made necessary changes in the stored procedure.
• Did the product support to explain the user the how the application can be used and what are the plus point of the application.
• Participated in the meeting with the users and gathered the issues raised by the user and took the action resolve it.

Confidential, Irving TX

SQL, SSIS, SSRS Developer

Responsibilities:

• Design and development of the SQL objects like Tables, Views, Stored Procedures, Indexes etc.
• Experience in DDL and DML.
• Experience in creating SQL jobs using agent.
• Wrote the complex SQL query using multiple joins for creating Ad Hoc reports using report builder based on the requirement.
• Planned, Defined and Designed data based on business requirement and provided documentation.
• Involved in complete SSIS life cycle in creating SSIS packages, Building, deploying and executing the package.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created the cubes for the departmental data mart.
• Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server.