SUMMARY

• 9+ years of IT experience in in Analysis, designing, developing, maintaining and building business applications such as data migration, integration, conversion, data warehouse and Testing.
• Experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modelling using Erwin. Create High Level and Low level document specifications.
• Extensive experience in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008R2/2012/2014 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS,SSIS, SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements for complex data warehouse in SQL Server Integration Services (SSIS).
• Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Teradata.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Wrote T - SQL queries, performance tuning, CTE’s, Sub queries and used them to build packages.
• Expertise in creating various types of reports, Charts and dashboards using SQL Server Reporting Services (SSRS).
• Supported team in resolving SQLReporting services and T-SQLrelated issues.
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Automated SSIS Packages by generating batch scripts.
• Wrote Complex SQLqueries for verifying data integrity in Dimension and Fact tables and created and have In-depth knowledge in various RDBMS concepts.
• Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like Teradata.
• Experience in Data warehouse created star schema and snowflakes schema data model and load data using ETL process using SQL server integration Service (SSIS).
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Good Knowledge on reporting tools like Power BI, QlikView, Tableau and Excel.
• Designed dimension and fact tables using Ralph Kimball methodology.
• Worked on complete Software life-cycle (SDLC) projects including Design, Analysis, Development, Quality Testing and deployment.
• Developed test plans, test cases and test scripts for Dimension and Fact Tables.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Key.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS

Languages: Transact- SQL, SQL,HTML, XHTML, C, C#, XML

SQL Server Tools: SSRS, SSIS, SQL server Query Analyzer, Business Intelligence Development Studio, Import Export Data, SQL server mail service, DBCC, BCP, SQL server profiler

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS.

RDBMS: SQL Server 2005/2008/2008 R2/2012/2014, Oracle 10g/9i/8i

Applications: Microsoft Word, Microsoft Excel, PowerPoint, Access.

Reporting Tools: MS Excel, SSRS, Qlikview, Report Builder, Crystal Reports and Business Objects

IDE’s: Eclipse, Visual Studio

Other Tools: Jira, Bugzilla, ALM, Team Foundation Server(TFS), RedGate SQL Compare, Microsoft Office, Microsoft Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, Huntersville, NC

Sr. SQL Server/SSIS/SSRS/ETL Developer

Responsibilities:

• Maintained and updated business intelligence tools, databases, dashboards, systems and/or methods created Ad-hoc reports for business users as needed.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, and script components.
• Learned the business processes at ATD in the context of how business intelligence solutions can be leveraged to enhance the business operations day-to-day.
• Expertise in creating, managing and delivering Server based reports using SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) in BI.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert from heterogeneous databases like MS Access and DB2. Developing enhanced ETL solutions in SSIS and validating the new and existing data
• Responsible for Training interns in ETL (SSIS).
• Implemented complex business logic with Store procedures, User Defined Functions, Views and wrote T-SQL batches with CTE (Common Table Expressions) for recursive operations.
• Extensive knowledge on Relational Database Management Systems
• Responsible for SQL Server logical and physical database design, implementation, and maintenance.
• Migration of databases from SQL Server 2008R2 to SQL Server 2012.
• Implement database refresh using SSIS packages and automated backup/restore jobs.
• Data Migration to and from various sources using SQL Server Integration Services (SSIS).
• Modeling or statistical analysis experiences.
• Strong knowledge and ability to use SQL and other tools to support analytical methods and database management.
• Developing Tableau Desktop reports & dashboards both as standalone and as secure Tableau Server reports.
• Perform data research, analysis, and logical data modeling to validate and document the usage of business data artifacts.
• Coordinated application security by working with the IT Security team to ensure the business users are granted appropriate privileges in the various BI systems.
• Managed Customer Service tickets elevated to Tier 2 support. Perform research necessary to prove/disprove application issue and create bug tickets for developers as appropriate.
• Identify and address root causes when solving problems. Work collaboratively with other departments and functional teams to coordinate effective solutions.
• Handle all business matters ethically and in full compliance with Confidential “Code of Conduct”.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Worked with tabular reports, matrix reports, gauges & chart reports, parameterized reports, sub reports, ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using SQLserver reporting services (SSRS).
• Worked closely with BI Business Analysts and developers to support Business Intelligence & Analytics solutions and to assure smooth ongoing operation of those solutions. The components of a solution included:
• Relational Databases
• Extract, Transform and Load (ETL) processes
• Reports
• Advanced analytics
• Data mining
• Other data visualization products
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
• Worked towards monthly report release and Report release BI tickets

Confidential, Los Angeles, LA

SQL Server/SSIS/SSRS/ETL Developer

Responsibilities:

• Responsible for Data Modeling based on the client requirements, daily maintenance and performance tuning.
• Gathered business requirements and analyzed and designed software solution for the Data migration from the Microsoft GP databases into the Warehouse and also to Windows Azure for AX Dynamics. Databases which will be used by application for POS systems and also linked to the AX Dynamics.
• Updated functional specification and technical design documents.
• Design pattern for the load process. Wrote Documentation for the designed packages.
• Created SSIS packages to extract data from OLTP to EDW systems and scheduled Jobs to call the packages.
• Designed SSIS Packages to transfer data from various sources like Excel Files, SQL Server using Business Intelligence Development Studio.
• Wrote T-SQL queries, Stored Procedures, CTE’s, Sub queries and used them to build packages.
• Designed, Developed and Deployed packages in SQL server environment using SSIS-2014. Using Visual studio 2012.
• Helped in the design of the Data warehouse model.
• Created cubes to feed the data for SSRS reports, which were earlier using only SQL server as the source for the data.
• Designed, modified and troubleshoot SSIS packages.
• Used SSIS to load data from various sources into on SQL Server 2014 database and created packages.
• 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.
• Involved in tuning and configuration of SSIS.
• Deployed SSIS packages from Development to Testing Servers for Covariance deployed the project in production.
• Debugging of SSIS packages by using data viewers and the audit logs generated with the Metadata.
• Designed and implemented event handlers, which are workflows that runs in response to the events raised by a package, task or container in SSIS.
• Involved in utilizing SSIS Checkpoint, Loading Dimension and Fact tables for Covariance
• Worked on Data Profiling in SSISand used Lookup component efficiently.
• Running and Scheduling SSIS Packages.
• For coordination among SQL developers used Team Foundation as the mean of communication.

Confidential, Minneapolis, MN

SQL Server/SSIS/SSRS/ETL Developer

Responsibilities:

• Responsible for Data Modeling based on the client requirements, daily maintenance and performance tuning.
• Good understanding of healthcare domain, HIPAA regulations and continuous communication with different stakeholders, clients like Medicare, Medicaid, CHIP.
• Production support, ad hoc queries meeting requirements from other development teams in a test driven agile development environment. Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database.
• Design and implementation of SSIS/ETL process for the system.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Design, develop, implement, and assist in validating ETL processes - full ETL development lifecycle.
• Data conversion from mainframe system and Oracle databases to SQL server.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles .Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Uses of power pivot, red gate tools for different purposes. Use of source control product such as Team foundation server.
• Modified stored procedures to meet current design and used them in SQL Server.
• Moving data from SQL server to Dynamics CRM and initial entity creation.

Confidential

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Gathered and analyzed reporting requirements for the sales and marketing departments.
• Created complex T- SQL queries, stored procedures, functions, triggers, joins and SSIS packages.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• DevelopedSSIS 2012 Packagesto migrate data from Oracle, Access, flat files and Excel into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations.
• 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.
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
• Wrote T-SQL queries, Stored Procedures, CTE’s, Sub queries and used them to build packages.
• Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
• Troubleshooting and analysis using commonly usedSQL trace event classes, identifying exceptions, debugging deadlocks and stored procedure debugging.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
• Formatted reports using Global Variables, Expressions and Functions for the reports using T-SQL in SSMS.
• Designed and developeddifferent type of reports including:Tabular forms, Matrix (crossTab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Experience in creating dashboards, scorecards and building reports using performance point server 2007 and deployed the report in SharePoint 2013.
• Configured Report Model for developing ad-hoc reports by the end-users.
• Uploaded reports on to the report manager and organized them into folders.

Confidential

MS SQL Server Developer/BI Developer

Responsibilities:

• Support the Debt Collection Application specifically application related Payment Imports and skip tracing of the consumer address information.
• Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data.
• Performance tuning to optimize SQL queries using query analyzer.
• Worked extensively in writing and debugging TSQL Scripting complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.
• Experience with the Share point to upload the SSIS packages in to Web portal.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Collected and analyzed data from various systems using pivot table and vlookup prepared monthly financial reports to identify unapplied cash and credits and allocated money to outstanding invoices.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Designing and building data load procedures using MS SQL Server.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Configured product meta-data tables to support client data reporting needs.Incremental and full database recovery with experience of complex recovery scenarios.