SUMMARY

• MS SQL Server Developer with Over 8+ years of strong experience in Information and Telecommunication, Finance and Market Research domains.
• Highly proficient in operating MS SQL Server 2012/2008 R 2/2008/2005/2000 suite of products like SSIS, SSRS and SSAS.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
• Proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Conversant in working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Proficient in Creating, Configuring and Fine-tuning MS SQL Server Integration Services.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Highly experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Expert in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Hands on experience in writing MDX queries to work with cube data.
• Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
• Conversant in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2008/2005.
• Strong leadership, communication, problem-solving and multi-tasking abilities. Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

TECHNICAL SKILLS

Operating Systems: Windows NT/98/2000/XP, Windows 2003 Server, UNIX

Languages: C,. Net,C#, VB.Net, XML, HTML, T-SQL, PL/SQL

Databases: MS SQL Server 2012/2008R2/2008, CRM, Oracle 9i/10g, MS Access, DB2

ETL Tools: DTS, SSIS (SQL Server Integration Services)

Tools: /Utilities: Enterprise Manager, SSMS (SQL Server Management Studio), Business Intelligence Development Studio (BIDS), DTA, SSAS, SSRS, SQL Profiler, ER win, Visio, Microsoft Office, Excel, Power Point, MsVisio2003/2007, MS Project, TOAD (for Oracle), VSS (Visual Source Safe)

Reporting Services: SQL Server Reporting Services (SSRS), Crystal Reports 2008

PROFESSIONAL EXPERIENCE

Confidential, Addison, TX

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Provide complete transactional history from AS400 production server to staging “Y” server, and providing maintainable and efficient performing staging layers
• Implement primary key structure in staging that is similar as that of source AS400
• Partition larger staging table based on timestamp
• Implement logical delete functionality in all tables, when data is deleted from source table it will be flagged delete but still store that data in separate table for history
• Support clients, including senior leaders, in the definition and attainment of organizational goals by identifying and addressing strategic issues, including root cause issue analysis and structuring problem solving approaches, often when no precedent currently exists
• Identify key business sales issues and develop appropriate business cases and action plans from multi-disciplinary perspectives
• Created SSIS packages for initial load from AS400 server to staging database, and implement CDC as per flags on row data
• Created data retention queries and SSIS packages to ensure amount of history to be stored in all CDC database.
• Created data manipulation and massaging scripts and procedures to ensure data quality and integrity
• Added several calculated fields while importing this data as per business requirements
• Created Merge queries to handle insert/delete/update flags from CDC (Change Data Capture) inflow data and updating target table accordingly
• Created SSRS dashboard report out of control table to monitor package runs for CDC process by matching row counts on source and destination tables
• Created view for business, to view data as per AS400 from SQL logical database.
• Knowledge of XML and Experience working with XML in SQL Server 2008.
• Developed SSIS Packages using xml, web services, ADO.NET, OLEDB, file system task in SQL SERVER Integration Services to upload and download the ETL DATA.
• Created several SSRS Subreports/Drill-through/DrillDown reports as per business requirement.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Participated in testing during the UAT (QA testing). Mentored and monitored team development and status.
• Configured the report viewing security for various users at various levels using Report Manager.

Tools: & Technologies: MS SQL Server 2012/2008R2, SSIS, SSRS, T-SQL, MS SQL Query Analyzer, SQL Profiler, Database Tuning Advisor and MS excel 2007, Visual Studio 2010/2012 (BIDS), AS400, iSeries, TFS, TOAD, JIRA.

Confidential, San Diego, CA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusing For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task,Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Knowledge of XML and Experience working with XML in SQL Server 2008.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Built data marts and cubes with SSAS for fast target data retrieval.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Deployed reports on Report Server and SharePoint Server also scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and company level.
• Created complex dashboard report based on statistical data provided by the users.
• Involved in table and indexpartitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimizeperformance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Tools: & Technologies: SQL Server 2012/2008R2, Server Integration Services 2012, SSAS 2012, SQL server Reporting Service 2012, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN 7.2, C#

Confidential, Los Angeles, CA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Performed Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access)
• Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML commands for various business applications.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Wrote C# script in Script task of control flow.
• Experienced in Error handling and debugging coding issues and troubleshoot production problems.
• Experienced in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor.
• Well-versed in usage of SSIS Control Flow items(for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping).
• Developed SSIS package for implementing Slowly Changing Dimension. Fact Load and Dimension Load. Incremental Load.
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Involved in configuring and creating SSIS solutions for ETL and Business Intelligence Process for data integration and migration services.
• Experienced in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

Tools: & Technologies: SQL Server 2008R2, ETL/SQL Server Integration Services (SSIS), MS Office 2007, Management Studio, MS SQL Query Analyzer, C#, .NET, Database Tuning Advisor, SSRS, Visual Studio (BIDS) and TFS.

Confidential, Dallas, TX

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.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008R2 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.
• 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 2008R2.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• Responsible for Monitoring and Tuning Report performance.
• Designing User Interface (C#, Win Forms), developing front-end parts.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools: & Technologies: SQL Server 2008/2005, BIDS 2008/2005, Integration Services 2008/2005, Visual SourceSafe, T-SQL, MS Access, Windows XP/2007 Server, SQL Profiler, Index Tuning Wizard, C#

Confidential, Dearborn, MI

SQL Server/SSIS/SSRS Report Developer

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference. Involved in installation and configuration of MS SQL Server 2005/2008.
• Involved in designing database and perform forward engineering, from conceptual data model to Logical and physical data model using Erwin 7.2 data modeler tool.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
• Extensive experience with optimizing existing stored procedures and various T-SQL queries.
• Involved in migrating data from MS SQL server 2000/2005 database to MS SQL server 2005/2008 database.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages. Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop )
• Developed Master Child Package by using Execute Package Task and Parent Package Variable Configuration.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure
• Developed unit test plans for SSIS packages. 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/Weekly/Monthly basis.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008. Generated Sub-reports, Drill down, Drill through and Parameterized reports using SSRS 20005/2008. Created reports to retrieve data using stored procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the dashboard. Responsible for monitoring and tuning SSRS Report Performance.
• Involved in the development and designing of XML, HTML using cascading style sheets for displaying the reports on the report server. Configured the report viewing security for various users at various levels using report manager.
• Fine-tuned SQL queries for maximum efficiency and performance. Provided documentation for all kinds of reports and SSIS packages. Designed and implemented stored procedures and triggers for automating tasks.

Tools: & Technologies: Windows 2003 server, SQL Server 2000/2005, DTS, SSIS, SSRS, T-SQL, MS Access, MS Excel, Oracle, VB, SSAS and Visual Studio 2005/2008.

Confidential

MS SQL Developer

Responsibilities:

• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created interface stored procedures used in SSIS to load/transform data to PRMS
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.

Tools: & Technologies: Windows 2000 Server, SQL Server 2005, HTML, T-SQL, SQL Loader, SQL Profiler, DTS