SUMMARY

• Around 7+ Years of strong experience in System Analysis and Design, Development & Support of MS SQL Server 2012/2008/ 2005 in Development, QA and Production Environments.
• Implemented SSIS, SSRS, SSAS and MDX for data warehouse & data mart solutions.
• Extensive experience in Extraction, Transformation and Loading (ETL) of data from multiple sources into Data warehouse using SSIS.
• Worked extensively in developing SSIS packages and jobs in SQL server.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) which includes Use Cases, Sequence, State and Activity diagrams, Data mapping, participated in architectural design and class design
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Worked on various database objects like indexes, views, triggers to maintain Data Security and Data Integrity.
• Extensive Knowledge of Data Warehouse Schema (STAR Schema and SNOWFLAKE Schema).
• Developed various reports and Dashboards of operational and research data of the organization using Power BI.
• Performed Quality Assurance of data loading between cube and warehouse using MS - Excel.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Extensive experience in SQL Server Reporting Services (SSRS) with Report authoring, Report Publishing, Report management, Report delivery and Report security.
• Created several Canned Reports, Customized Reports, On-Demand Reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Used SQL Performance Tools like SQL Server Profiler to trace the stored procedure calls.
• Extensive experience in writing and debugging SQL Server Objects like Tables, Views, Stored Procedures, Functions, Cursors, Triggers, Indexes.
• Strong Experience in creating Drill down, Drill through, parameterized, Cascade parameterized, Sub, Linked, Charts and Snapshots using SSRS based on Relational and Multidimensional databases
• Strong experience in design and construction of data marts, data views and data mining. Experience in Building Multi-Dimensional Cubes, Data Modeling, and OLAP Cubes using SSAS.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

RDBMS/DBMS: SQL Server 2012/2008/2005 , MS Access, and SQL Plus

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, SharePoint, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS),PowerBI

Data Modeling: ER-Win v 4.0, Visio 5.0

Reporting Tools: Crystal Reports, MS Excel, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

Programming Languages: C#.NET, ASP.NET,VB.NET,Visual Studio.net, Visual Basic, SQL,TSQL, PL/SQL, C, C++, HTML, XML/XSL/XSLT, CSS3.0,MDX

Operating System/Servers: Windows 8/Windows Vista/Windows XP, IIS 5, 6

Analysis Services: MS SQL Server Analysis Services, DashBoard for BI

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

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

SQL/BI Developer

Responsibilities:

• Work with Claims data to provide seamless Regulatory Reporting for Federal and state requirements.
• Performing T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer.
• Extensively worked on converting SAS code to SQL and using them for generating reports to meet the standards
• Participate in the development and implementation of data migration using best practices throughout the enterprise through the data migration tool
• Understanding FACETS data dictionary so that data can be pointed to integrated data store.
• Developed various reports and Dashboards of operational and research data of the organization using Power BI.
• Work within the data migration strategy and roadmap to increase the usability, completeness, and accuracy of enterprise data throughout the company systems and applications
• Worked on various database objects like indexes, views, triggers to maintain Data Security and Data Integrity
• Involving in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designing SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Following Data Warehousing methodologies and concepts, including Star schemas, snowflakes, dimensional modeling.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view during extraction of data.
• Experienced in using automated deployment processes using tools like Team City and Octopus Deploy.
• Using Git Hub and TFS as a source controller for all this development.

Environment: MS SQL Server 2014/2012, Microsoft TFS, SQL Server Master data Services (MDS), SQL Server Reporting Services, SQL Analysis Server, SAS, SVN, GitHub, Microsoft Visual Studio, Share Point, MS Excel, T-SQL MS-Access

Confidential, Shawnee Mission, KS

SQL/MSBI Developer

Responsibilities:

• Working on a variety of development technologies, practices, and procedures and relies on extensive experience and judgment to plan and accomplish project goals. SSRS/SSIS, SQL, IIS, C#, .Net
• Designing, customizing, developing and testing SSRS/SSIS in a multi-tier software systems environment.
• Demonstrating strong knowledge in SSIS, SQL, SSRS Report design, IIS, XML, consuming/creating web services.
• Gathering the requirements and Designing the report per the documented requirements
• Developing the report per the documented design utilizing identified tool like SSRS
• Unit Test of developed report and develop test data if required to support testing.
• Develop execution method (Tidal) and Assist with Production Deployment as necessary
• Reviewed, performed unit and system testing, and fixed bugs for SSIS package, and SSRS reports using SQL 2012 Data Tools.
• Created complex queries to build the dataset required for developing the SSRS reports.
• Designing the Implementation document to move the reports to production Environment and assist with other teams in the process
• Creating/ Modifying the mapping documents based on the client requirements and legacy reporting system
• Establishing connections to views in HDFS with ODBC connection through PostgreSQL
• Creation/Execution of complex queries in PgAdmin III using PostgreSQL query window required for SSRS reports.
• Comparing the legacy and the latest SSRS reports for accuracy and modify them to exactly match the legacy systems
• Created Table objects like Stored Procedures, Indexes, Views, Functions, Triggers and other user defined functions to optimize and improve response time to meet the business requirements.
• Used advanced TSQL techniques like MERGE, CLR, CTEs, UDFs, Cursors and partition switching.
• Created Visual Studio database projects for Schema and Data comparison to generate builds for different environments.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent

Environment: SQL Server 2014/2012, Visual Studio 2013, SQL Server Data Tools (SSIS, SSAS, SSRS), SSMS, HP ALM Quality Center, PCX Reports, Tidal Jobs, Report Builder 3.0, PostgreSQL, PgAdmin III, HDFS, SVN, SharePoint 2012, TFS 2013, T SQL, Agile.

Confidential, St. Louis, MO

SQL/BI Developer

Responsibilities:

• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Implemented various data loading methods (Bulk Load, BCP, SSIS packages) and assisted in analyzing business requirements with SME (subject matter expert).
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Extracting/Migrating the data from the different sources (CSV files, oracle, Text based files and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Migration is also done using Bulk Insert and dynamically created queries in the job steps.
• Scheduled and maintained routine jobs, tasks, and alerts.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Developed and deploys SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Troubleshooting reports issues, ETL job failures, optimizing the existing TSQL statements to improve query performances.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services
• Involved in developing various reports as per business needs using SSRS.
• Involved in creating store procedures for SQL Server job automations and also to check conversion errors.
• Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule

Environment: MS SQL Server 2012, Microsoft Visual studio 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), .Net, T-SQL, Visual Studio 2010, SQL Profiler, Red gate Database suite, Visual Source Safe, Data tools. Team Foundation Server, UNIX, MS Office

Confidential, Fenton, MO

MS SQL Server Developer / BI Developer

Responsibilities:

• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Creating scripts to execute batch processes and SQL for data validation
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Following Data Warehousing methodologies and concepts, including Star schemas, snowflakes, dimensional modeling.
• Creating Multidimensional cubes using SSAS and designing DW schemas.
• Implementing Key Performance Indicator Objects in SSAS 2012. Create Calculate member in MOLAP cube using MDX in SSAS 2012.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS.
• Understood the various complex reporting requirements of company and created web reports using Reporting Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Modified report content and exported reports in multiple formats based on user input.
• Developed solutions for programming scenarios using C#.NET.
• Created User Defined functions for sharing formulas across multiple reports.

Environment: MS SQL Server 2012, SQL Server Integration Services(SSIS),SQL Server Reporting Services(SSRS),SQL Server Analysis Services (SSAS),C. Net,T-SQL, Visual Studio 2010, SQL Profiler, Redgate Database suite, Visual Source Safe, Data tools.

Confidential, Ann Arbor, MI

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Created many complex database code objects such as Stored Procedures/ views/ Functions and used them in Reports directly to generate reports on the fly.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008 R2.
• Assisted data modeler to create tables needed for ETL processing and develop ETL framework.
• Used SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2008 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Implementing Key Performance Indicator (KPI) Objects in SSAS. Create Calculate member in MOLAP cube using MDX in SSAS
• Following Data Warehousing methodologies and concepts, including Star schemas, snowflakes, dimensional modeling.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view during extraction of data.
• Managed things properly even though working remotely most of the time with some travelling.
• Helped team in creating Master Data and established processes to have less issues in referring different versions of master data in MDS
• Used script task for selecting the latest file in a group of files from the folder as a source file using Object oriented C#.net
• Used TFS as a source controller for all this development.

Environment: MS SQL Server 2012/2008 R2, Microsoft TFS, SQL Server Master data Services (MDS), SQL Server Reporting Services, SQL Analysis Server, C#.NET, Microsoft Visual Studio, Share Point, MS Excel, T-SQL, MS-Access

Confidential, Louisville, KY

SQL BI Developer

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Extensively worked on Data Flow tasks like foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008R2 using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Worked with various SSIS packages which involve Transactions, Restart ability and roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the Report Server.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Server Agent for scheduling jobs and alerts.

Environment: SQL Server 2008R2/2008, SQL Server Reporting Service(SSRS), SQL Server Integration Services (SSIS), Management Studio, Visual Studio, XML, XSLT, MS Office and Visual source safe.