SUMMARY

• Having 8 years of experience in MS SQL Server suite of products like SSIS, SSRS and SSAS of DBA/ Developer MS SQL Server 2014/2 .
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSIS,SSRS, SSAS) using SQL Server 2014/2012/2008 R2/2008.
• Extensive ETL experience using SSIS for Data Extractions, Transformations and Loads.
• Hands on experience in all phases of SDLC (software development life cycle) and Agile methodology involving Requirement analysis, Software design, development, implementation, testing, maintenance.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2012/2008R2/2008.
• Extensive experience in Analysis service development (both star and snow flake schemas) of multi - dimensional models and tabular models using SQL Server 2012/2008R 2/2008/2005.
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T-SQL and relational database models.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Expertise in creating Property Expressions, Script Tasks for SSIS packages.
• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
• Converted data using Derived Column, Data conversion transformation and Script task.
• Created packages for error handling, logging and custom logging to log the error information to SQL Server, Flat files and XML files.
• Experience in Creating, Modifying Measures, Dimensions Attribute relationships and Hierarchies.
• Expert in designing and developing Tabular models.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Extensive experience in providing Enterprise Reporting solutions using SSRS 2014/2012/2008 R2/2008, Power BI tools ( like power query, power pivot, power views )and SharePoint Services.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Adhoc and Sub Reports.
• Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Also implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Experience in creating automated administrative functions such as backing up and restoring databases, copying SQL Server databases and the objects they contain, copying SQL Server objects, and loading data using SSIS.
• Good knowledge in using DMVs and DMFs in resolving Performance Issue, Data modeling concepts.
• Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, analyzing the execution plan and index management for better Query Optimization.
• Created Database maintenance plans for compressed full DB backup and transaction log backup.
• Configured\Monitored\Supported and Troubleshooting of multiple databases on Cluster environments to provide High Availability and Disaster Recovery
• Setting up and monitored Disaster recovery environments like Database mirroring with in the primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction with Log Shipping.
• Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company’s Security Policies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Preparation of Unit Test plans and Unit testing ofCOGNOSReports/ETL jobs and Published Cubes and Reports toCognosConnection through Framework Manager and used Analysis Studio to view the cubes.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Created SSIS Packages for Incremental loading and slowly changing dimensions.
• Report / Cube development usingCognos8.x, Transformer and Analysis Studio.
• 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 SSIS. Executed the DTSX Packages by using DTExec Command.
• Excellent technical, communication and interpersonal skills with very good troubleshooting and problem solving skills. Ability to work on multiple tasks in a fast paced environment independently and in a team.

TECHNICAL SKILLS

ETL Tools: MS SQL Server Integration Services (SSIS)/DTS/BCP

RDBMS: MS SQL Server 2012/2008/2005, Oracle 12c/11g/10g, IBM DB2, MS Access

Database Tools: Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Database Engine Tuning Advisor

Reporting Tools: MS SQL Server Reporting services (SSRS), Crystal Reports 9.0.

Data Modeling Tools: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT, Dimensions)Physical and Logical Data Modeling, ER-Win, MS Visio, MS-Office

Languages: SQL, T-SQL, PL/SQL, Unix Shell Scripting, C#,C, C++, HTML, CSS, PHP, Core JAVA

IDE: Microsoft BIDS/SSDT, Microsoft Visual Studio 2005/2008/2008 R2

Operating System: Windows 7, Windows 2003/2000/XP/98, Linux and UNIX

Applications/Web: ASP.Net, Microsoft Share point, MS excel, word, power point, MS Visio, MS Outlook 2007/2012, Cogon’s 8.0, Cognos10 Report Author.

System Design: Requirements Gathering and Analysis, Data Analysis, ETL Design, Development and Testing UAT Implementation

Performance Tools: Perfmon, SQL Profiler, TOAD, MS Studio, SQL * Plus, Putty

Monitoring Tools: SQL Sentry, RedGate, SQL Native, CommVault.

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

SQL Server Developer /SSIS/SSRS/SSAS

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQ L.
• Developed and deployeddatatransfers packages to the appropriate destinations using SSIS.
• CreatedSQLserver configurations for SSIS packages.Used SSIS transformations to implement the Slowly Changing Transformation, to maintain HistoricalDatainDatawarehouse.
• Created various staging tables forconversionpurpose to cleaning thedatawhile converting from old system to new system.
• Used SSIS transformations to implement the Slowly Changing Transformation, to maintain HistoricalDatainDatawarehouse.
• Designed both logical and physicaldatamodels in Erwin.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for DataScrubbing,datavalidation checks during Staging, before loading thedatainto theDatawarehouse.
• Created various staging tables forconversionpurpose to cleaning thedatawhile converting from old system to new system
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL)datainto theDatawarehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Developed Cubes using SQL Analysis Services (SSAS), Involved in creating Named calculations and named queries.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Experienced in creating and maintaining SSAS databases in both Multidimensional model and Tabular models in SSAS.
• Created Package Configurations to deploy the packages through DEV, TEST and PROD Environments.
• Developed the New columns & Measures using Power Query.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2014 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Scheduled the DTS package for migration data from old system to MS SQL 2014.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Creating reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
• Deploying and scheduling reports using SSRS to generate all daily, weekly, and monthly and Quarterly Reports including current status.
• Created APCD Address Validation Reports for Different Modules for various time periods like Monthly, Quarterly, annually in SQL Server Reporting Services
• Developed reports using global variables, expressions and functions using SSRS.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS) (2008 R2/2012/2014).
• Designed and developed automated processes for generation of data files to be sent to Trading Partners.
• Developed SSIS packages for data migration from various kinds of source files (.txt, .tab, .xls, .xml, and .csv) received.
• Created SSIS Packages for Transaction processing using containers as For-Each Loop, Sequence & controlling flow of data using tasks as Script, Data Flow, File System, and Execute Package.
• Used TFS (Team Foundation Server) for Source Control.
• Debugging, maintenance and optimization of ETL packages, SQL jobs using SQL Server best practices.
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Attained legacydatato use as a source to develop new reports previously compiled and maintained manually.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• 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 etc.
• Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.

Environment: Microsoft SQL Server 2014, 2012, 2008 R2/2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ASP.Net, C#, MS Access, Agile Scrum Methodology, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, TeraData.

Confidential, Harrisburg, PA

Sr. SQL Server MSBI

Responsibilities:

• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Designed and implemented backup plans as per the data- retention policy outlined in the BRD (Business Requirement Document).
• Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during the activity.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• 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 like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SSIS.
• Deployed SSIS packages with a simple one-click deployment to the integration server and also using .NET language.
• Used SQL Sentry to check the blockings, TOP SQL, and memory issues and DISK I/O issues.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring.
• Creating new Databases and Migrated SQL Server 2008 databases to SQL server 2014 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.
• Moved databases from SQL Server 2008/2014.
• Created Linked servers for distributed queries.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Configured database mail to inform corresponding DBA basis on each Job Status.
• Created the SQL server users and file server users with required permissions by including them in the scripts. Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS).
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• CreatedCognosFramework model andCognosreports using Teradata.
• Experience in both integration and reporting areas of Data Warehouse using ETL,Cognos, Business Objects, Teradata.

Environment: MS SQL Server 2008 R2/2012, Cognos8.0, ASP.Net 4.6, C#.net 4.0, ADO.Net, MS SQL Integration Services 2008 R2/2012, Crystal Reports, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, MS Excel Power Pivot, IBM DB2, Teradata

Confidential, Miami, FL

SQL Server Developer/ SSIS/SSRS

Responsibilities:

• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training and Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
• Uploaded Letter/Fax Templates to Dev, QA & Prod using Pharmacy Prior Authorization tool by determining Source and Template keys by using SQL queries.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Experienced in loading/updating the Prior Authorization data into Facets. Involved using the Facets UMI Web Service to look for Prior Authorization data for Database applications. Loading ICD-9 and ICD-10 codes from Excel files to SQL Server tables.
• Used SSIS jobs for importingdatafrom the flat files that brings thedatato the application tables.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for the application.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed SSIS packages for File Transfer from one location to the other using FTP task.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using Business Object and Crystal reports.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Conducted weekly Crystal Reports training session for the reports team.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.

Environment: SQL Server 2012, SSRS 2012, SSIS 2012, Excel, T-SQL, Windows 2008/XP, C#, ASP.NET, Visual studio

Confidential

SQL DEVELOPER/DBA

Responsibilities:

• Developing and implementing plan for Disaster Recovery.
• Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions
• Used SSIS and T-SQLstored procedures to transferdatafrom source databases to staging area and finally transfer intodatawarehouse.
• Developed and deployeddatatransfers packages to the appropriate destinations using SSIS.
• CreatedSQLserver configurations for SSIS packages.
• Troubleshoot issues with log file full and database size increasing Confidential threshold errors.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and Troubleshooting Failed Jobs.
• Monitor Database consistency and heath using DBCC Commands and DMVS.
• Hands-On experience on monitoring using SQL Sentry, And Script out the schema using Red Gate
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting thedata, defining datasource and subtotals for the reports using SSRS /2005.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• 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)
• Worked with business users to understand metric definitions, presentation, and usage needs.

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, MS Access, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL, MS SQL Server DTS, Upgrade Advisor, DTS Designer Tools.

Confidential

SQL/Teradata DEVELOPER

Responsibilities:

• Interact with the users to understand requirements and document them.
• Analyzing the system requirements, business logic and specific line of business.
• Responsible for Daily Data Loads using SQL * Loader and Fast Load Script into VEDWH.
• Involved in the Data migration activities to load the Data into different DB Schemas.
• Effectively supporting for decision making throughout the organization.
• Reviewed many T-SQL issues using management studio for better performance.
• Testing and validating the data on Impromptu reports as well asCognosCubes.
• Customer segmentation (LVC, MVC, HVC & UHVC) based on the usage behavior.
• Analyzing calling patterns of customers across various legs of usage Local, STD and ISD. Designed and implemented data access stored procedures and triggers for automating tasks.
• Played a prominent role during the onsite deployment in Democratic Republic of Congo by identifying a major software bug, which otherwise could have caused a million-dollar revenue loss to the client.
• Analyzed subscriber’s mobile usage patterns and created analytics based segmented mass marketing campaigns which helped the telecom·operatorto achieve a significant increase in the recharge value during the year 2010.
• Created Architect model usingCognosArchitect from different sources
• Created numerous user behavior reports by identifying, understanding, analyzing the factors leading to customer rate and ARPU (Average revenue per user) drops
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Created many complex Stored Procedures / Functions and used them in to generate reports on the fly.
• Providing consultation on SQL Server to our development teams.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Interacted with the business users to gather information about the report.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• 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 Generated reports using SSRS which were sent to different Clients.

Environment: MS SQL Server 2005, ASP.Net 3.5, C#.net 3.5, ADO.Net, Business Intelligence Development studio, Microsoft.NET, MS Office Access 2003, MS Office, MS Outlook 2003, VBScript, Tomcat, Cognos6.6, Teradata Sql Assistant