SUMMARY

• Having 8+ years of IT Experience with SQL server Developer, Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2012/2008/2005 , SSIS, SSAS and SSRS
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2012/20 .
• Experienced in client requirement Analysis, Physical, Logical design, development, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2012/20, DTS, SSIS, SSAS and SSRS.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T - SQL Scripts.
• Experience in writing complex SQL queries involving multiple tables Inner and Outer Joins.
• Experience in optimizing the queries by creating various clustered, non-clustered Indexes and Indexed Views.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Expert in designing reports using SQL Server Reporting Services (SSRS) based on OLAP cubes.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence in SSRS.
• Experience in developing Custom Reports and different types of Tabular, Matrix and Distributed reports into multiple formats with SQL Server Reporting Services (SSRS).
• Expert in enhancing the reports visually by adding the visual elements including charts, graphs, gauges and maps to SSRS reports.
• Experience in creating SSIS packages based on multiple data source including SQL Server, Flat File, Excel and MS SQL Server.
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Designed SSIS package to extract appropriate records and output them to DM Warehouse.
• Experience in developing scripts in SSIS to synchronize stored procedures, email output and log messages.
• Designing and maintaining data management and data processing solutions using SSIS, includes Error Handling and Slowly Changing Dimensions.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages in SQL Server.
• Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Experience in normalize and de-normalize data in the process of building database and reporting.
• Familiar with process of testing, troubleshooting and debugging on each unit of work, including jobs, SSIS package, SSRS reports and SSAS cubes.
• Expert in migration of databases from older versions of SQL Server 2008 to SQL Server 2012.
• Extensive database programming Experience in developing complex T-SQL queries including Stored procedures, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server2008/2012 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Worked Extensively on ETL process using SSIS package.
• Perform XML validations.
• Use TDM tools to search, catalog and vend test data
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS.
• Expertise in testingETLProcesses, Reporting, Financial Processes and Web Services
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Perform Data Profiling and Data Analysis on large volumes of Data.
• Used Tableau to visually analyze data and create concise and actionable dashboards
• Experienced in Database Testing and Automation
• Expertise in defining the business process flow and gathering Business Requirements.

TECHNICAL SKILLS

Programming Skills: C, Java, TSQL, PL/SQL, .NET Framework

Web Technologies: HTML, CSS, XML, Java Script, Ajax, JQuery, SOAP

Database: SQL Server 2012/2008/2005 , Oracle

Management Tools: SQL Server Management Studio, SQL Server Query Analyzer, SQL Profiler, SQL Server Enterprise Manager, Import & Export Wizard

Development Tools: Visual Studio .NET 2012/2010, SSIS, SSAS, SSRS, DTS

Web Servers: IIS 7.0, Apache Tomcat, Web Sphere

BI Tools: ERWIN, Tableau, Crystal Reports,Power BI

Operating Systems: Server 2012/2008, Windows 97/Xp/Vista/7/8/10, UNIX/LINUX

Bug Tracking: Bugzilla

PROFESSIONAL EXPERIENCE

Confidential, SC

SR. MSBI Developer

Responsibilities:

• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Worked with different methods of logging in SSIS.
• Experience in creating Table Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services2008 and SSRS 2012.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SSIS, SSRS, MS SQL Server 2012/2008, C#, Visual studio 2008, MS Access, MS Excel, MS Office Access 2007.

Confidential, Chicago

Sr. MSBI Developer

Responsibilities:

• Designed and created various business reports using SSRS 2012 versions
• Created reports with stored procedures and also involved in scheduling, creating snapshots and subscriptions for the reports in SSRS.
• Formatted reports according to End user needs.
• Created a wide variety of reports using report builder.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status..
• Created reports using Excel and Microsoft Office 360.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and Customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created several SSIS packages to load data from different sources like SQL server database.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, etc.) and loaded the data into the target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS packages using various control flow tasks like For each loop, File system task, Execute SQL task and Dataflow task etc.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Scheduled the jobs to run daily, weekly, monthly as per requirement.
• Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors using 2012 SSMS Versions.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2008) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Design and create report models based on user requirements, explain and train users to use report builder to generate their own personalized reports.
• Wrote T-SQL code to extract data which answered business questions.

Environment: SQL Server 2012, Visual Studio 2012,2010, SSRS, report builder, T-SQL, Windows Server, SQL Reporting services, ASP.Net, MS Access.

Confidential, Virginia

MSBI Developer

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Experience in monitoring SQL Server Performance tuning in SQL Server 2008R2/2012 using SQL Profiler, Query Analyzer.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table. Generated ASP.net objects from tables and presented these DOM objects which are capable for easy communication, to the Business applications.
• Created the deployment scripts after the development is done for every project.
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Troubleshooting the SSIS/SQL job Agent whenever necessary.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Used SQL server SSIS tools to build high performance data integration solutions including Extraction, Transformation and Load packages for data warehousing. Extracted data from the XML file and loaded it into the database
• Constructed cubes based on data volumes mostly adhering to Star Schema.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Used custom .NET assemblies for Script Task in SSIS
• Imported the various files provide by the clients into the relational database systems.
• Used the BCP to load the large volumes of data from files into tables.
• Worked with Business Analysts and Users to understand the requirement.
• CreatedSSISPackages 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 tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Documentation for all kinds of reports andSSISpackages.
• Used Visual Source Safe as Version Control Tool.

Environment: SQL Server 2012, SQL Server Business Intelligence Development Studio 2012, SSIS, SSAS, SSRS, T-SQL, EXCEL, Performance Point Server, T-SQL, C#, Visual Source Safe, SQL prompt.

Confidential, CA

MSBI Developer

Responsibilities:

• Installation and configuration of SQL Server 2008 R2.
• Designed and created SSIS packages to extract, transform and load data from Excel and Text to SQL Server destination using various complicated transformations like conditional split, derived column, and data conversion for fee schedules from the existing QNTX database.
• Modified the existing packages by making changes in the stored procedures according to the requirement.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008R2.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report services (SSRS).
• Used various data flow transformations like conditional split, look up, derived column etc.
• Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.
• Strong knowledge in Databases, Data ware house concepts, ETL process and Business Intelligence.
• Designed Cube partitioning, Partition Slicing and Synchronization for SSAS cubes.
• Strong knowledge in Power BI on how to import, shapes, and transform data for business intelligence (BI).
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Involved in performance tuning for new databases and existing databases by using SQL profiler.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Involved in troubleshooting, enhancing and creating new ones of claims retro report templates.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), SSAS, SSRS, OLTP, Visual Studio 2010, SQL Server Management Studio, Excel, TFS, Windows XP.

Confidential

MSBI Developer

Responsibilities:

• Installation and configuration of SQL Server 2008 R2.
• Managing of database objects like Tables, views, indexes etc.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Well experienced with tools like Query Analyzer, SQL utility.
• Implementation of data transfer through DTS and setting guidelines to automate recovery scenarios.
• Creation and management of Database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Automation and execution of data transformation scripts.
• Used SQL Loader as an ETL tool to load data into the Staging Tables
• Used DTS packages as an ETL tool for migrating data from the SQL Server 2000 to Oracle 10g
• Improved the performance of the application by rewriting the SQL queries
• Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, coding and testing.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Optimized SQL queries for improved performance and availability.
• Designed, analyzed and upgraded databases.
• Developed Transact-SQL scripts to enforce business rules.

Environment: MS SQL Server 2008, Windows 2008, MS Access, T-SQL, DTS, VB 8.0.

Confidential

SQL Developer

Responsibilities:

• Involved in the life-cycle of the project, i.e., requirements gathering, design, development, testing and maintenance of the database.
• Setup new SQL Server instances.
• Developed SQL Server objects such as tables, materialized views, clustered and non-clustered indexes, stored procedures, cursors, triggers and constraints.
• Performed query optimization and tuning, debugging and maintenance of stored procedures.
• Provided database security by using role base authorization on accessing data.
• Used System tables and stored procedures to retrieve metadata.
• Administered the database using SQL Server Enterprise Manager.
• Performed troubleshooting operations on the production servers.
• Monitored SQL Server jobs, and developed queries to perform database operations.
• Developed user friendly GUI using HTML and ASP.NET to display and access data.
• Implemented database programming by using the ADO.NET object Model.

Environment: SQL Server 2005, DTS Package, SQL Server Enterprise Manager, SQL Server Query Analyzer.