SUMMARY:

• Over 8 Years of working experience as SQL Server Database developer in Analysis, Design, Development, Administering, Implementing and Testing Client/server application.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Master in T - SQL Programming, SQL stack including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Profound knowledge and ability to write complex stored procedures, Cursors, complex queries including correlated queries with complex joins and aggregate functions and to create temporary tables, views, indexes and triggers.
• Expertise working on logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Designed SQL Server database objects (tables, stored procedures, functions and views) to support outsourcing data integration (SSIS), analysis, and various business processes.
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from Excel files, flat files, legacy systems and loading into SQL server.
• Experience in Importing/Exporting Data from various data sources like MS Access, Excel Files, Oracle, DB2, XML Files and Flat Files using DTS utility. Involved in ETL transformation of OLTP data to the Data Warehouse implementing all transformations using SSIS and SQL commands.
• Hands on experience on parsing XML files to SQL Server tables using Open XML commands.
• Eperience in migrating DTS packages, deploying and scheduling SSIS packages as jobs using SSIS 2005/2008 as batch process.
• Mastery in installing, developing and deploying reports using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes using Report Designer as well as Report Builder.
• Experience in generating Drill down reports, crystal Reports, Parameterized reports, Linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008/2010.
• Extensive work experience in development of SSRS, Power Pivot Reports.
• Expert in T-SQL coding, testing functions, ad-hoc SQL queries, views, triggers, cursors, data types, indexes, and system tables.
• Modified existing OLAP cube to extract historical data to support healthcare cost utilization analysis and actuarial reporting (SSRS).
• Strong knowledge in reporting implementation of Crystal Reports/Webi Reports/ SQL server Reporting Services SSRS and SQL server Analysis Services (SSAS)
• Experience in administration tasks such as data loading, data uploading, backup & recovery, configuring IIS, Database mirroring, Log shipping, batch jobs, Replication Services, upgrades.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Worked on creating Parameterized Reports.
• Experience in using Team Foundation Server(TFS)
• Experience with using TortoiseSVN as Source Control
• Master in the Installation, Registration, Configuration, Database Backup/Recovery and Disaster Recovery procedures for MS Server 2000/2005/2008/2008 R2/2012
• Experience in ASP.NET coding.
• Good in implementing SQL Server Security and Process Control.
• Designed and documented reporting and information management strategies for various industrial, financial, healthcare and insurance domains.

TECHNICAL SKILLS:

Databases: SQL Server 2014/ 2012/2008/2005 , 7.0,MS Access, DB2,Oracle 9i/10g

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, Database Tuning Advisor, SQL Profiler, Enterprise Manager, Query Analyzer, Redgate.

ETL Tools: SSIS 2014/ 2012/2008/2005 , DTS, BCP (Bulk Copy Program)

Reporting Tools: SQL Server Reporting Services 2014/ 2012/2008/2005 (SSRS), Crystal Reports Performance Point Server 2007, SAP Business Objects XI 3.1, Web Intelligence.

OLAP Tools: SQL Server Analysis Services 2012/2008/2005

Programming Languages: SQL, T-SQL, PL/SQL, Oracle 9i, VB Script.

Operating Systems: Windows (95/NT/2003/2008)

Business Tools: MS Word, MS PowerPoint, MS Excel, MS Project,Xcelsius

Web Development Tool: HTML, XML

Applications: AME (Advertising Market and Execution), Retail EMR.

WORK EXPERIENCE:

Confidential, St.Louis, MO

SR .MS SQL Server BI Developer(SSIS/SSRS)

Responsibilities:

• Experience in application development and implementation.
• Experience in relational database model, design, development and performance tuning (SQL 2014).
• Experience in Data Warehouse dimension modeling.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Development experience working with large databases.
• Experience in gathering requirements and development of technical/functional specifications.
• Worked with agile software development techniques including designing software for unit testing and acceptance testing, and use of continuous integration.
• Experience with full lifecycle software development.
• Experience with using TortoiseSVN as Source Control
• Experience with using SQL Data Compare Redgate
• Understanding Program specifications based on Business and Data requirements and to develop ETL solutions based on these requirements and specifications.
• Understanding upstream and downstream systems and processes including impact and gap analysis of current databases and reporting systems.
• Ability to write complex SQL queries, stored procedures, functions and triggers to support complex business needs.
• Performing Data analysis using SQL tools to query databases and provide technical assistance.
• Supporting and troubleshooting production processes and issues.
• Working with other ETL developers in the team to ensure smooth transition of data requirements into code.
• Analyzing data to understand business impact and proposing new changes and alternative solutions to existing data structures.
• Migrating SQL server jobs with dependencies to AutoSys.
• Creating testing scenarios in Development environment to test and validate data integrity of the SSIS packages.
• Experience in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Experience in creating SSIS packages using Script task (Vb.net,c#) and Script Component.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Parameterized Control flow and Data Flow using variables and expressions in SSIS Package to achieve business needs and business requirement.
• Routinely analyzing, testing and cleaning data to ensure data integrity.
• Following company policies and procedures and maintaining constant security awareness since the position has access to sensitive data.

Environment: Windows 7, MS SQL Server 2012/ 2014, SQL Server Management Studio (SSMS), T-SQL, SQL Server Report Services (SSRS), SSIS, Microsoft Excel, Redgate, TortoiseSVN, CA Workload Automation AutoSys Edition.

Confidential, Franklin, TN

SR. MS SQL Server BI Developer(SSIS/SSRS/T-SQL)

Responsibilities:

• Experience in working with the Data modeling team in design of Logical and Physical models.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers and created documentation for the same.
• Experience in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports.
• Developed Stored Procedures in SQL Server 2012 and modified existing stored procedures as needed.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Capturing error data in flat file using flat file destination, sending the error data in flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data.
• Experience in providing Error handling by using Event Handler for SSIS Packages.
• Experience in working with different methods of logging in SSIS.
• Using SSIS built high performance data integration solutions, including extraction, transformation and loading (ETL) packages for Data Warehousing.
• Experience in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Experience in creating SSIS packages using Script task (Vb.net,c#) and Script Component.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension .
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Co-coordinating with Informatica team to migrate certain tables and data from Oracle Server to SQL server.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, List items, Charts and Linked reports.
• MDX Coding and MDX object modeling using analysis services
• Created SQL Server Reports based on the requirements using SSRS 2012.
• Created reports in visual studio 2010 using shared Data source and stored procedures as datasets
• Conditional formatted the reports for applying different styles to report items or properties, based on the data
• Custom coded the report as per the necessity by embedding the code directly in the report
• Deployed the reports and Created subscriptions for the reports in report manager
• Experience with using Team Foundation Server (TFS) as Source Control.
• Performance tuning the query to reduce the cost and the time of execution
• Experience in creating snapshots of reports to reduce the load on the server.
• Developed data extraction and output specifications for reports based on analysis of end user’s requirements
• Gathered specifications from internal customers to understand requirements, analyze data and provide valid report designs
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Implemented report subscriptions and methods for report distribution based on agreed timelines and according to specifications

Environment: Windows 7, MS SQL Server 2008 R2/ 2012, SQL Server Management Studio (SSMS), T-SQL, SQL Server Report Services (SSRS), SSIS, Microsoft Excel

Confidential, Boston, MA

MS SQL Server BI Developer

Responsibilities:

• Experience in complete Software Development Life Cycle.
• Experience working with Business Users and Business Analysts in gathering the requirements
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Created User Defined Functions, Stored Procedures, and Triggers.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Experience in creating complexSSIS packages using proper control and data flow elements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle,DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
• Created data loads and Performed Data validations
• Created packages inSSIS with error handling.
• Worked with different methods oflogging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Havedeployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Monitoring the jobs in case of heavy data loads and high memory usage. .
• Worked on SSRS to generate reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used MS Team Foundation server for Code Check -in and check out.
• Prepared documentation related to database design, Low-Level-Design Documents, Service Level Agreement and Unit testing plan and scripts

Environment: SQL Server2012/2008R2, TFS, SSIS, SSRS, T-SQL, SharePoint server 2007.

Confidential, OH

MS SQL Server Developer(SSIS)

Responsibilities:

• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Migrated data from various sources into SQL Server using SQL Server Integration Services
• Created complex reports which includes cascade parameters, multivalve parameters and conditional formatting to generate user friendly reports.
• Created reports using Reporting Services 2008 to retrieve data using database code objects such as stored procedures, views and multiple T-SQL queries.
• Developed packages in SSIS for aggregating data files and database sales information and consolidating for reporting & cubes.
• Used multiple transformations in SSIS such as Conditional Split, Bulk Insert, Merge and Data Conversion.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications
• Developing Reporting in SSRS Report Viewer Control and integrating to Web application as client side reporting.
• Wrote SQL scripts to Insert, Update and Delete data in MS SQL database.
• Created database, tables and procedures to update and clean the old data.
• Dropped and recreated the Indexes on tables for performance improvements.
• Configured and maintained Report manager and Report Server for SSRS.
• Created Drilldown-Reports, Summary Reports, Parameterized Reports, Sub Reports, List Reports and Matrix Reports in SSRS.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration.
• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot), Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SQL Server Reporting Services.
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Designed and developed reports using SQL Server Reporting Services
• MDX Coding and MDX object modeling using analysis services
• Developed Stored Procedures and Views used to supply the Data to the Reports.
• Developed reports where the data extracted from SSAS cubes in SSRS.

Environment: SQL Server 2005/2008, Management Studio, SQL, PL/SQL, ETL, DTS, Integration Services, Notification Services, Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS), Data Modeling, T-SQL, SQL Profiler, Windows

Confidential

MS SQL Server Developer

Responsibilities:

• Verified the databases for data entry errors
• Created and managed schema objects such as Tables, Views, Indexes and Stored Procedures
• Created database triggers in T-SQL to check the referential integrity of the database
• Worked with the developing team in the writing functions in Visual Basic 6.0 for Upload and download functionality, Data transfer and migration
• Transformed data from one server to different servers using data transformation services (DTS)
• Developed SQL queries to collect complex data from different tables in remote databases using joins
• Effectively included in Normalization & De-normalization of databases
• Managed version control and documentation of all SQL Server objects
• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Assited in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
• Create T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Managed rollback segments, and table spaces to ensure less space used by the database.
• Created documentation on the all the tables, stored procedures, views and user defined functions.