SUMMARY:

• Over 8 years of extensive experience in database design, development and administration with MS SQL Server versions 2012/2008/2008 R2/2005/2000 using SSIS, SSAS, SSRS (BI Tools) in finance, healthcare, insurance and marketing domains.
• Strong experience in creating T - SQL objects, working with DDL/DML, performs most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business
• Experienced with SQL Server and T-SQL in constructing Stored Procedures, triggers, tables, user defined functions, views, indexes and new SQL functionality such Common Table Expression, Temp Table and Merge.
• Experience in developing ETL mappings and scripts using Informatica PowerCenter 9.1.1 (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
• Entities(Data Warehouse, Data mart).
• Expert in creating traditional as well as Web-based interactive reports using SSRS.
• Experienced in creating score cards, dashboards and building matrix and tabular reports and drill down and drill through reports.
• Experienced in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse, data marts as well as transactional systems.
• Experienced in developing and modifying cubes and dimensions in cubes using SSAS.
• Experienced in multidimensional data modeling, cube development and optimizing using SSAS.
• Experience in Dimensional Data Modeling and Relational Data Modeling, Star Join Schema/ Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Excellent Knowledge of Software Development Life Cycle, RDBMS, Data Warehouse & Data Modeling concepts.
• Excellent problem solving, analytical, technical and interpersonal skills with strong leadership abilities and an extremely diligent strong team player with an ability to take new roles.

TECHNICAL SKILLS:

• MS SQL Server 2014/2012/2008 R 2/ 2008/2005/2000
• MS SSRS /2005/2000
• MS SQL SSAS 2008/2005/2000
• MS SSIS 2014/2
• Python, DataRama, AWS
• Informatica9.1.1
• (Power Center)
• DTS, Erwin Designer 2000
• Power designer
• DB2 SQL syntax
• MS-Access, C, C++
• VB 6.0,Developer 2000
• Erwin 7.3/4.2/4.2/4.0
• Oracle 9i/10g
• T-SQL, PL/SQL
• TFS
• ASP.NET
• Sharepoint 2010
• HTML, XML, XSL
• Visual Studio 2005/2008/2010
• Crystal Reports, Power BI,MS Office
• Autosys,UC4
• Windows NT/ 2000 Server/ XP
• Windows
• Windows 7, Windows 8

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL/SSIS /ETL Developer

Responsibilities:

• Analyzed, designed, and gathered business requirements.
• Created SSIS reusable packages to extract data from multi formatted flat files and excel files into SQL Database.
• Scheduled and monitored different jobs using SQL Server agent.
• Involved in checking and validating jobs and notify on failures (Monitoring and debugging of daily job failures).
• Designed SSIS jobs and create reusable components to support the data exchange with our clients. Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Interacted with Business Analysts and Developers in identifying the requirements, designing, and implementing the Database Schema.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Worked on several transformations in Data Flow including Derived-Column, for each loop, Script task, Data Conversion, Conditional-Split and many more.
• Wrote T-SQL queries, Store Procedures, used them to build packages, and handled slowly changing dimensions to maintain the history of the data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Used version control (TFS) for specific client.
• Worked after hours for production issues and support as part of the on call duty.
• Using python code for to download files from Amazon Web Service (AWS).
• Loading files in to DataRama Dash board.

Environment: MS SQL Server 2008R2/2012/2014, SSIS, T-SQL, Visual Studio 2008/2012/2014 , MS Office 2007/2003, Windows 7, Python, Datarama

Confidential, Durham, NC

SQL /SSIS Informatica Developer

Responsibilities:

• Optimized Stored Procedures and Views using performance tuning.
• Performed unit testing on Interfaces at ETL level, with Testers as per testing standards and UAT with Users.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Developed packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Created data pull procedure, SSIS packages and data or evidence documentation involve with different work stream.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables to store the data into SQL.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Used TFS while creating ETL packages .
• Migrated packages from development server to production server using package configuration.
• Created Informatica objects- Sources/Targets/Reusable Transformations, Mapplets, Mappings, Sessions, worklets, Workflow and Folders.
• Scheduled jobs using Autosys.
• Creation of ETL’s as per requirements. Deployed ETL Interfaces between Development, Test and Production Repositories.
• Created User Defined Functions, indexes to generate the distinct data based on the type of the customer base.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.

Environment: MS SQL Server 2008R2/2008, SSIS,SSRS 2008, T-SQL, Visual Studio 2008, Informatica9.1.1(Power Center),MS Office 2007/2003,Sharepoint 2010,SQL Profiler, Windows 2000/2003/XP,ADO.NET 3.5/3.0,ASP.NET 3.5/3.0

Confidential, Denver, CO

SQL /SSIS/SSRS/SSAS Developer

Responsibilities:

• Perform manual tasks (downloading data files from third party vendor website, treasury report), Generate data samples for monthly processing.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Developed packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Created data pull procedure, SSIS packages and data or evidence documentation involve with different work stream.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables to store the data into SQL.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Migrated packages from development server to production server using package configuration.
• Involved in creating fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).
• Identified and modified the Key Performance Indicators (KPIs), measures in co-ordinance with the requirement.
• Extensively used SQL Server Reporting Services 2008 with relational and multidimensional data.
• Involved in creating C# scripts using script task in SSIS.
• Created dynamic reports using SSRS for the monthly connections and details of all locations, generated report models using report builder for the end users.
• Scheduling reports on a weekly basis that was generated every Friday containing the details of weekly sales for our location for assessing the business for that week.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS. Used “SQL Profiler TSQL Duration” template for tracking execution time of TSQL Statements.
• Created User Defined Functions, indexes to generate the distinct data based on the type of the customer base.

Environment: MS SQL Server 2012/2008R2/2008, SSIS,SSAS,SSRS 2008, T-SQL, Visual Studio 2008, MS Office 2007/2003, SQL Profiler, Windows 2000/2003/XP,ADO.NET 3.5/3.0,ASP.NET 3.5/3.0

Confidential, Midland, MI

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.
• Involved in upgrading packages from SQL server 2005 to SQL server 2008
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Wrote T-SQL queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Involved in creating OLAP cubes and dimensions for the analysis using SSAS.
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Used “SQL Profiler TSQL Duration” template for tracking execution time of TSQL Statements.
• Creation of ETL’s as per requirements. Deployed ETL Interfaces between Development, Test and Production Repositories.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, SSAS, Visual Studio 2005, VSS 2005, Erwin 7.2, Windows NT/2003,Microsoft .NET framework 3.5, C#, XML

Confidential, Jacksonville, FL

SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Confidential is a leading provider of title insurance, mortgage services and restaurant and other diversified services. The project was involved in extract and load data into MS SQL server 2008 and 2008R2 database and creation of SSIS packages to integrate the data contained in various heterogeneous file systems and SQL Server database and creating reports using SSRS 2008.
• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2005, instances, Oracle Databases and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Configured SQL Mail agent for sending automated alerts/email.
• Gather requirements from users at chat sessions and interviews.
• Adept at preparing business requirements documents, defining project plans, writing system requirement specifications.
• Developed Pl/Sql procedures & functions to support the reports by retrieving the data from the data warehousing application.
• Provided documentation for all kinds of reports and SSIS packages.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Created SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Developed high level daily summary report (Flash Report) and monthly business summary report (Monthly Management Report) and distributed these reports across different business units.
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, SSAS, BIDS, Microsoft Visual studio 2005, Windows server 2003.

Confidential, Virginia Beach, VA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Created SSIS package to load data from staging environment to production environment using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• Worked in writing, testing and implementation of the Triggers, Procedures, Functions at Database level and Form level using Oracle.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible to create all the SSRS report using Cube as data source.
• Performed Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: SQL Server 2008/2005 enterprise edition SP3, BIDS, SSRS, SSIS, SSAS, Oracle 10g, Windows server 2003

Confidential, Philadelphia, PA

Junior MS SQL Server / SSRS /SSIS Developer

Responsibilities:

• Assisted project manager in project planning schedule for database module.
• Used highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from SSIS to make the flow of SSIS effective.
• Used multiple join statements to retrieve data from multiple tables.
• Worked on SQL profiler to view indexes performance to mostly eliminate table scan.
• Tested procedures and triggers before moving into production.
• Created various SSIS packages for data transfer and migration from OLTP to OLAP.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Analyzed and designed disaster recovery / replication strategies along with business managers to meet the business requirements. Identified and defined the Datasets for the report generation.
• Wrote the queries for generating different reports and identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: MS SQL Server 2005, SSIS, MS Excel, Windows 97/2000/XP

Confidential, Boston, MA

Junior SQL Server Developer

Responsibilities:

• Installed and configured MS SQL Server and Applied service packs and hot fix.
• Migrated databases from SQL server 2000 to SQL server 2005.
• Logically and physically designed database for projects on basis of user requirements using ERWIN.
• Wrote various Stored Procedures for the purpose of application development.
• Performed Database backups (operating system, flat file backups & export/import).
• Created complex Stored Procedures.
• Used Query Analyzer to optimize SQL Queries.
• Converted various SQL statements into Stored Procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time).
• Coded Procedures & Functions in MS SQL server 2005.
• Successfully loaded data from an EXCEL, Access into a SQL Server database Table.
• Loaded data from Flat files (. txt) into SQL Server Using SSIS 2005.
• Involved in query monitoring for the queries that were passed through Cognos.
• Provided technical support to internal developers and external clients Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2005/2000,SSRS,T-SQL, Enterprise Manager, Windows 2000 Server, MS Office, Erwin