SUMMARY:

• Around 8+ years of MS SQL Server Development experience in Finance, Telecom, and HealthCare and Insurance domains with expertise in MS SQL Server 2000/2005/2008/2012/2014 and suite of products like SSIS and SSRS.
• Experience in Data Design and Development on Microsoft SQL Server T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
• Extensive experience in using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading (ETL)
• Hands on experience with features and functions of Microsoft SQL Server 2012.
• Experience on data migration from SQL Server .
• Very good working experience of T-SQL.
• Expertise in scripting T-SQL queries, Complex Stored Procedures, User Defined Functions (UDF), Database Triggers, using tools like SQL Profiler and Database Tuning Advisor (DTA).
• Used Sub-Queries and Joins to simplify complex queries involving multiple tables.
• Expertise in creating, maintaining database objects like Indexes, Functions, views, Triggers, UDF's, constraints.
• Hands on experience in Performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes.
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in bulk importing CSV, XML and Flat files data using Bulk copy program BCP.
• Experienced in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Very Strong skill in building and using CTE's (Common table Expressions) for building recursive queries.
• Experience in Monitoring, Job Scheduling, Troubleshooting, Back Up, recovery and system upgrading.
• Closely working with category for implementation master data management (MDM) of new products, customers and vendors.
• Very strong implementation of Microsoft Business Intelligence(BI) platforms including SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS) and Microsoft office SharePoint Server 8 in SQL Server
• Experience in designing, configuring, deploying SSIS packages and providing security for packages.
• Implemented incremental Load for many SSIS packages.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapp let and Mapping Designer.
• Experience in Error handling, Debugging, error logging for production support in SSIS.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• SQL Server OLAP online analytical process database development including KPIs, Data mining, working with changing dimensions.
• Performed Logging and Deployment of various packages in SSIS.
• Experienced in enhancing and deploying the SSIS Packages from development server to production server.
• ETL implementation using SQL Server Integration Services (SSIS), Reporting Services (SSRS).
• Developing reports on SSRS on SQL Server
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Implemented parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS.
• Experienced in administrating the created reports and assigning permission to the valid users for executing the reports.
• Involved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star, Snowflake, Normalized and De-normalized Schemas with respect to query and analysis requirements.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Experienced in Creating and Updating Statistics to improve the SQL Server Performance.
• Good knowledge Database Console Commands (DBCC).
• Experienced in managing Data and Transaction log files, Files Groups.
• Experienced in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Senior MSBI Developer

Responsibilities:

• Involved in gathering, understanding and validating the project specifications.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services-2008.
• Good Knowledge and working exposure in Informatica Power Center 9.5
• Developed complex T-SQL queries for the ETL packages.
• Designed packages in SSIS 2008 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.
• Good understanding and experience in SQL 2008 new features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
• Built Synchronous and Asynchronous scripting component for different modes of output.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Created packages with Ragged Right data mapping.
• Closely working with category for implementation master data management (MDM) of new products, customers and vendors.
• Migrating from Informatica 7.1.4 mappings into Informatica 8.5.1 which consists of grid technology.
• Understanding the domain and nodes as well as by using the Informatica integration service to run the workflows in 8.5.1
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Created user variables, property expressions, script task in SSIS.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Designed Cascading (Collapsed), Printable, interacted reports (drill-down and sorting functionality).
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Confidential, Denver, CO

MSBI Developer

Responsibilities:

• Work closely with management and end-users to create and evaluate business requirements.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Used different Control Flow Tasks and Data flow Tasks for creating SSIS Packages. Designed packages using different types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Involved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.
• Involved in Extraction, Transformation amp; Loading (ETL) process and used Informatica Power Center tools
• Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor
• Implemented Informatica 8 new SQL transformation for executing SQL statements.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drilldown Reports.
• Experience in writing custom code expressions in SSRS.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Created Report Models for Business Users to create their own reports.
• Designed & created OLAP Cubes with Star schema using SSAS 2008 R2.
• Created Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Create and maintain data model/architecture standards, including master data management (MDM).
• Used master data management (MDM) to define reference data
• Managed security and user access to Analysis Services cubes using creation of Groups and Roles by creating windows AD and also Perspectives within the OLAP cube.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or cube processing or other ETL jobs didn't interfere with each other. Managed SQL 2005 and 2008 R2 databases and nightly SSIS Processes.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Monitoring the scheduled SSRS and Crystal reports. Re-running the reports in case of any failures or data mismatches.
• Involved in deploying the changes to QA, Staging and Prod environments.
• Managed off shore team in Report migration project.
• Followed agile methodology and coordinated daily scrum meetings.
• Involved in Product Releases and support calls.

Confidential, St. Louis, MO

SQL Developer/MSBI Developer

Responsibilities:

• Extensively used ETL Components to Extract Data from Different Sources
• Design and development of SSIS packages to fetch data from different data sources
• Worked on Business Objects XIR3 including Designer, Desktop Intelligence, Web Intelligence, Info View, BOMM crawlers
• Creation of reports using prompts/ combined queries, report level filters.
• Working on Test cases of SSIS Packages and Data cleansing
• Developed C#, VB.Net scripts as part of ETL coding
• Development of UNIT test cases and prepared technical specifications for SSIS packages
• Implementation of CDC Techniques and applying standards like logging check points, and package configurations
• Creation of source Queries at Analysis and Designing phase
• Preparation of mapping documents and technical design documents based on client requirement specifications
• Creating merged dimensions at report level by using multiple data providers
• Checking of PDF and excel views of reports for formatting issues
• Testing of reports for data validation at different levels and preparation of Test results document
• Universe and Reports Migration from Dev to UAT to Prod
• Worked in performance tuning and deployment phase
• Creation of BOMM crawlers on different databases, packages of SQL Server2008
• Scheduling of BOMM Crawlers
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements
• Developed different type of reports by using SSRS and SQL Server 2008/2012

Environment: MSBI (SSIS, SSRS), SQL Server 2008/2012, Biz-talk, BO-SDK, Mantis, VB.net, PVCS

Confidential, Denton, TX

MSBI Developer

Responsibilities:

• Developed optimized stored procedures, T-SQL queries, User Defined Functions (UDF), Cursors, Views and Triggers, SQL Joins and other statements for benesmart reporting Application, maintained referential integrity and implemented complex logic
• Enhancing the layouts available for the reports in the BeneSmart application
• Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Gather requirements from business user and modify the stored procedures, codes to provide functionality as required.
• Perform including filters to the reports and make it parameter-driven
• Perform including SQL Agent jobs to update source of data by use of SSIS package.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Deploying the reports to staging server prior to business user acceptance testing.
• Perform including security to the reports and data in the application
• Implement updates of reports in BeneSmart application to recognize same-day data updates/changes.
• Doing release builds and fixing issues related to reports in staging environment of BeneSmart application.
• Created data driven subscriptions for different users using Report Manager.
• Proficient with Dynamic HTML, XML, CSS, for building a dynamic flexible and highly interactive Real-Time User Interface.

Environment: SQL Server 2008 Enterprise Edition, MS SQL 2008 r2, SQL Server BI Suite(SSRS, SSIS and SSAS), Microsoft Visio 2003, MS EXCEL 2007.

Confidential

SQL Server Developer

Responsibilities:

• Created tables, indexes, sequences, constraints, triggers & procedures. Used DDL & DML commands for writing triggers, stored procedures, and data manipulation.
• Designed stored procedures and triggers for automating tasks.
• Developed database objects such as Stored Procedures, CTE, Functions, Tables, Triggers and Indexes using T-SQL.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Development of custom scripts and stored procedures for data import and manipulation.
• Fine-tuned DML, DDL scripts with lock hints for performance boost.
• Defined check constraints, Business rules, Indexes, and Views.
• Developed PL/SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Helped in integration of the front end with the PL/SQL backend. Learning and Knowledge acquirement for the BANCS services.
• Created PL/SQL package to schedule the jobs for batch processing. Used PL/SQL Profiler and query analyzer to optimize queries and stored procedures.
• Configured Server for sending automatic mails to the respective people when a process failure or success. Performed development support, document reviews, test plan, integration of the system.

Environment: Windows, SQL Server 2008 R2/2012, SQL Integration Services (SSIS), SQL Reporting (SSRS), Business Intelligence Studio, Visual Studio, OLE DB, Erwin.