SUMMARY:

• Over 8+ years of IT experience as a SQL Server Developer in Design, Analysis, Development, Modeling, Implementing and Testing of decision Support Systems using MS SQL Server 2005, 2008, 2008R2,2012,2014Services.
• Good knowledge and exposure to different phases of Software Development Life Cycle (SDLC),Agile and Scrum Methodologies.
• Experience in writing T - SQL (DDL, DML and DCL) scriptsin all MS SQL server environments.
• Proficient in creating Index, Views, Complex Stored Procedures, CTE’S appropriate functions, and effective Triggers to facilitate efficient data manipulation and data consistency in MS SQL Server 2014/2012/2008 R 2/2008/2005.
• Database Maintenance Plan design to keep track of the performance of MS SQL Server, which covers updating database statistics and Re-indexing of clustered and non-clustered indexes in production environment.
• Highly proficient in Tuning SQL queries, improving the query performance and hands-on experience in optimization and performance tuning using SQL profiler, Index tuning wizard and Execution plan.
• Expert in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Excellent hands-on experience with data modeling tools and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.SQL Server Services (DTS, SSIS, SSRS, SSAS)
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2005/2008/2008 R2/2012).
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2012/2014) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Expertise in building and migration of various DTS packages.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Experience with file transfer protocols, including standard FTP and SFTP
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Experience using different Version Control Tools like Confidential Source Safe and CVS.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Hands on experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005/2008 Analysis Services.
• Expertise in using Confidential ReportingService (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Created various Complex Formula Reports to query the database for business Intelligence.
• Strong ability in defining query for generating drill through,drill down reports,canned and cache reports withdrop down menu option, sorting thedata, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2005/2008.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Proficient in creating Data Mapping Document for providing source and destination mappings. Deployed reports on report server.
• Developed reports using global variables, expressions and functions.
• Proficient in scheduling and creating reports using SQL Server Agent.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• A well-organized, goal-oriented, highly motivated and effective team member with excellent analytical, troubleshooting, and problem solving Skill.
• Excellent Verbal & Written Communication skills and strong in Documentation.

PROFESSIONAL EXPERIENCE:

Confidential, EDEN PRAIRIE, MN

Sr. SQL Server&MSBI DEVELOPER

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Proficient in creating Index, Views, Complex Stored Procedures, CTE’S appropriate functions, and effective Triggers to facilitate efficient data manipulation and data consistency in MS SQL Server 2014/2012/2008 R 2/2008/2005.
• Database Maintenance Plan design to keep track of the performance of MS SQL Server, which covers updating database statistics and Re-indexing of clustered and non-clustered indexes in production environment.
• Highly proficient in Tuning SQL queries, improving the query performance and hands-on experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan
• Worked on Developing ETL Design documents and Worked on Mapping documents.
• Developed Custom SSIS Framework which can do logging, error handling and can implement dynamic incremental loading.
• Created several SSIS packages for performing ETL (Extract, Transform and Load) operations from OLTP to OLTP and OLAP systems.
• Worked on Performance tuning for slow running SSIS Packages and could find out of root cause of the performance issues.
• Worked on Dynamically configuring the Complex SSIS package which can work in different environments with minimal configuration changes.
• Worked on SSISDB Catalogs for doing project deployment model using ISPAC files.
• Pulled the data from multiple database sources such as DB2/TeraData/SysBase and flat file sources that includes CSV, Excel, Mainframe (SAS).
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Expertise in building and migration of various DTS packages.
• Strong experience in creating and publishing packages in Framework Manager.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Concepts worked on Logging, Event Handlers, Script task, Script component, FTP task, different kind of data source like flat file, excel & other RDBMS, Debugging/Troubleshooting.
• Expertise in using Confidential Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Created various Complex Formula Reports to query the database for business Intelligence.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2008/2008R2.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008/2008R2 Reporting Services.
• Recently implemented new Azure SQL Server cloud database environment in the Company and has exposure to azure and part of the team to implement in current working database.

Confidential, ROUND LAKE, IL

Sr.SQL Server&MSBI DEVELOPER

Responsibilities:

• Responsible for creating Databases, Tables, Indexes, Unique/Check Constraints, Views, Stored Procedures, User defined functions, Triggers, Rules and Defaults.
• Proficient 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, Pivot).
• Created various packages in SSIS, for data conversion using various transformation tasks.
• Having hands on experience in DR Processes including LogShipping and DatabaseMirroring.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Implementing all high availability techniques like clustering, log shipping, replication.
• Working knowledge with DMExpress ETL tool to filter data based on end requirements.
• Working experience with Column store indexes, table partitioning in SQL SERVER 2012.
• Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.
• Enhancing and deploying theSSIS Packages from development serverto UAT server.
• Worked on to develop Report Structure with data definition, report layout and report definition language.
• Created various Complex Formula Reports to query the database for business Intelligence.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports withdrop down menu option, sorting thedata, defining subtotals and handling parameterized reports and creating report layouts using SSRS.
• Developed different kind of reports such a sub reports, charts, matrix reports, linked reports.
• Worked in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Scheduled daily jobs using SQL Server agent for loading data.
• Performed tuning of SQL queries and stored procedures.

Confidential, EDEN PRAIRIE, MN

Sr. SQL Server&MSBI DEVELOPER

Responsibilities:

• Created various packages in SSIS, for data conversion using various transformation tasks.
• As part of SQL Server DBA,I am responsible for the migration, maintaining and mapping of data from disparate legacy systems (AS400).
• Having hands on experience in DR Processes including LogShipping and DatabaseMirroring.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked on the development and sustainment of the SQL Server Data Repository(warehouse), executing data loads, ETL using SSIS, and performing data modeling in support of multiple development teams for our online applications.
• Worked independently and collaboratively as per team guidelines.

Confidential, MADISON, NJ

Sr.SQL Server&MSBI DEVELOPER

Responsibilities:

• Involve in complete Software Development Lifecycle (SDLC).
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirements and System Specifications
• Migrated data from paradox database to SQL Server 2008.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for creating Databases, Tables, Indexes, Unique/Check Constraints, Views, Stored Procedures, User defined functions, Triggers, Rules and Defaults.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS
• Created various packages in SSIS, for data conversion using various transformation tasks.
• Enhancing and deploying theSSIS Packages from development serverto UAT server.
• Worked on to develop Report Structure with data definition, report layout and report definition language.
• Created various Complex Formula Reports to query the database for business Intelligence.
• Strong ability in defining query for generating drill through,drill down reports,canned and cache reports withdrop down menu option, sorting thedata, defining subtotals and handling parameterized reports and creating report layouts using SSRS.
• Developed different kind of reports such a sub reports, charts, matrix reports, linked reports.
• Worked in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Scheduled daily jobs using SQL Server agent for loading data.
• Performed tuning of SQL queries and stored procedures.
• Involved in writing complex procedures for Crystal reports.
• Involve in production support 24/7
• Involve in HEAT ticketing system for daily issues.
• Involved in different projects Trident, Eos, Homebase prompt, Relo and support the systems.
• Designed ETL for TM1 process.
• Worked with Cognos developers for all DBA related issues and enhancements from DB side.

Confidential, MINNEAPOLIS, MN

Sr.SQL Server&MSBI DEVELOPER

Responsibilities:

• Worked on T-SQL programming , Stored procedures , user - defined functions , views and management of linked servers toSQL-Server and Non-SQL-Server databases.
• Created complex SQL stored procedures using Confidential SQL Server 2012.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Checked Performance Tuning, Indexing, Query Optimization.
• Worked with project manager and technical leads for resolution of technical issues.
• Create reports based on data analysis and provide Heat-Mapping and Indicators in reports to help in effective handling of fraudulent activity.
• Created UDF’s, triggers, Stored Procedures for maintaining real-time servers which have 3 months’ worth of data which pull data from data warehouse.
• Created Indexes, both clustered and non-clustered for improving in performance as the tables contain huge pile of data.
• Created database maintenance plans and deleting of history data using SSIS packages
• Created several SSIS packages for performing ETL (Extract, Transform and Load) operations from OLTP to OLTP and also OLAP systems.
• Performing the tasks of data conversions, adding derived columns, data conversions,sending results in mails is done by making use of various tasks in SSIS .
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008, flat files etc.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Implemented Event Handlers and Error Handling in SSIS packages.
• Configured the loading of data into Slowly Changing Dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into data warehouse.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 R2 to MS SQL 2012as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in all the environments (Development, Test and Production
• Data Migration from legacy to master tables using DTS-Import and Export wizard.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Worked in Agile environments.
• Familiarity working with source control systems and deployment technologies such as Visual Studio/Team Foundation Server (TFS).
• Unit testing and integration testing experience.
• Build Feed Solutions - Develop and administer feeds to ensure flow of data and media to and from business partners.
• Develop imports to and extracts from existing SQL databases.
• Use various source and targets to build flows - XML, Flat File, Web Service, JPEG, etc.
• Administer databases and database servers - Actively participant in the analysis, design, implementation, testing, documentation and maintenance of all database environments.
• Tune and optimize the performance by regular evaluation and monitoring of databases and their objects to identify and resolve performance and reliability issues.
• Troubleshoot in all database environments using available tools to diagnose and resolve issues.
• Backup and restore of databases for disaster recovery, testing and development work
• Deployment of database solution code.
• Migrate code to various environments and Participate in code reviews

Confidential, Redmond, WA

Sr.SQL Server&MSBI DEVELOPER

Responsibilities:

• Worked on T-SQLprogramming , Storedprocedures , user - definedfunctions , views and management of linked servers toSQL-Server and Non-SQL-Server databases.
• Created complex SQL stored procedures using Confidential SQL Server 2012 and 2014.
• Strongly Implemented Common Table Expressions (CTE).
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Created several SSIS packages for performing ETL(Extract, Transform and Load) operations from OLTP to OLTP and also OLAP systems.
• Performing the tasks of data conversions, adding derived columns, data conversions,sending results in mails is done by making use of various tasks in SSIS .
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008, flat files etc.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Implemented Event Handlers and Error Handling in SSIS packages.
• Configured the loading of data into Slowly Changing Dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 R2 to MS SQL 2012as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSISETL tool.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in all the environments (Development, Test and Production).
• Experience in developing reports using SSRS 2008 R2, 2012.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML.
• Experience in BI concepts like Data warehousing & Data Marts.
• Worked on Cosmos for the internal project in Confidential .
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to analysts to review in Excel Sheet.
• Deployed Reports to Production Servers.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Performed the task of data transfer from files in remote server to folders in another server using FTP .

Environment: MS SQL Server 2014/2012/2008 R2 SQL Integration Services 2012, Confidential Visual Studio 2012, SQL Server Management Studio, MS Excel, T-SQL, Cosmos,DataMarts.

Confidential, Bellevue, WA

Sr.SQL Server&MSBI DEVELOPER

Responsibilities:

• Analyze d business requirements and build logical data models that describe all the data and relationships between the data.
• Create d data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Deploying new Database objects in production environment.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (Power BI) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Testing and loading the data on Development and Production.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases

  Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.

• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Implementing Common Table Expressions (CTE) is strongly done.
• Worked with project manager and technical leads for resolution of technical issues.
• Create reports based on data analysis and provide Heat-Mapping and Indicators in reports to help in effective handling of fraudulent activity.
• Created UDF’s, triggers, Stored Procedures for maintaining real-time servers which have 3 months’ worth of data which pull data from data warehouse.
• Created Indexes, both clustered and non-clustered for improving in performance as the tables contain huge pile of data.
• Monitoring jobs to pull huge data into real-time server for analysis purposes.
• Attending meeting with clients and upgrading and handling existing reports based on end-user requirements.
• Carried out migration to a secure sandbox environment and implementing security levels, encryption and certification on the server to ensure safety to sensitive data.
• Created cube for daily calculations of customer feedback based on different attributes and figuring out the satisfaction of customer and time and money spent on handling the call.
• Created multiple SSIS packages and deployed them to pull in data from 5 different sources regularly and use stored procedures for modifications in data and obtained derived tables to be used in reports.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Added filters, columns, parameters, color coding to existing reports for user - friendliness.
• Monitored report manager granting access to end users based on level they need to look data at and providing the end-user with a clean and easily understood user-interface.

Environment: SQL Server 2005/2008R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Confidential Office Share Point Server, HTML, JavaScript, C#net,ASP.net, XML,CSS, MS Visual Source Safe and Windows Server 2008R2.

Confidential, Minneapolis, MN

SQL Developer (OFF SHORE)

Responsibilities:

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Conducted data migration processes in the SQL Server environment using SSIS.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMS like SQL Server and Oracle 10g.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data into consistent and reliable data, and finally load it into a Multi-dimensional data warehouse.
• Created copies of operational Databases using the Import/Export Wizard.
• Monitored the performance of Database objects using Performance Monitor that ships with SQL Server 2005.
• Developed Triggers to raise events on executing insert, delete and update stored procedures.
• Optimized existing stored procedures to achieve improved performance.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
• Generated reports using the Crystal Reports and Reporting Services 2005.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005.
• Developed XML tags to structure data and improve the data migration process.

Environment: SQL Server 2005, Windows Server 2003, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Erwin 3.5.2/4.0