SUMMARY

• Highly motivated Developer with 9+ Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL server integration services (SSIS) and SQL Server reporting services (SSRS).
• Extensive hands - on experience with data preparation - extraction, cleansing and transformation. Proven ability to deal with large amounts of data
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, SQL Profiler and other database related activities
• Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Experience in creating databases, transactions, tables, indexes, constraints, writing and debugging stored procedures, triggers, views, functions and cursors using SSMS & SQLCMD in Microsoft SQL Server
• Highly skilled in T-SQL - simple and complex joins, sub-queries, stored procedures, triggers, cursors, functions, views, CTE, DDL, DML
• Hands on experience working with Microsoft Team Foundation Server.Good Knowledge about Extracting, Transforming and Loading (ETL) data using Import/Export Wizard and SSIS.
• Worked on predefined, developed stored procedures for automation and scheduling in crystal reports.
• Developed reports using SSRS on SQL Server (2005/2008/2012 ).
• Experience with Adhocreporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill Through, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Involved in SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS
• Strong experience in understanding and analyzing business requirements.
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

• MS SQL Server 2008/2012 (SSRS/SSAS/SSIS)
• Data Transformation Services (DTS)
• Oracle 9i/10g
• ODBC
• OLTP
• OLAP
• SQL Server Management studio (SSMS)
• DAX
• MS SQL Server 2000 Enterprise Manager
• SQL Query Analyzer
• SQL Profiler
• Bulk Copy Program (BCP)
• Share Point Server MOSS 2007
• Business Object Crystal Report.
• Windows 2000 Advanced Server
• Windows 2003 Enterprise Server.
• Visual SourceSafe (VSS)
• Team Foundation Server (TFS)
• C
• C++
• T-SQL
• VB6.

PROFESSIONAL EXPERIENCE

Confidential, Chevy Chase, MD

MS BI Developer

Responsibilities:

• Designed and createdSSISpackages 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.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2012.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Designed and implemented NextGen templates and Crystal reports for several Medical practices.
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, deployed, and maintained complex canned reports using SQL Server 2012 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Created SSRS reports which contain Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
• 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 2012, SQL Server Integration Services (SSIS), SSAS,SSRS, OLTP,DAX,C#, Business Intelligence Development Studio, Power Pivot, SQL Plus, SQL, Server Profiler, SQL Server Management Studio.

Confidential, Crystal River, FL

ETL/ SSIS Developer

Responsibilities:

• Designed and developedSSIS(ETL) packages to Validate, Extract, Transform and Load data from OLTP system to the Data warehouse
• Created Stored Procedures, User Defined Functions, Views and T-SQL Scripting for complex business logic.
• Created Stored Procedures which generated the necessary Fact and Dimension tables and Functions that allowed performing necessary calculations depending upon the requirements.
• Formulate designs and/or design recommendations which meet various requirements; balancing the goals and constraints of existing solutions.
• Convert business requirements into actionable technical requirements for the project.
• Worked on 3 terabytes of data warehousing storage, with multiple years of historical data.
• Provide technical solutions within BI team in the design process for the project.
• Designed and Built ETL packages to migrate data from different source systems using Data vault modeling concept.
• Implemented various automated UNIX shell scripts to invoke pl/sql anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
• Design and build reporting and analysis tools that help streamline the business and make reporting, analyzing, planning, and forecasting more efficient.
• Worked on ETL Load SSIS Packages, report / cube creation and data visualization including dashboards and reports leveraging charts (Pivot tables), gauges and drill-through.
• Created SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
• Support team projects with technical expertise with all aspects of the solution design and implementation, including requirements definition, data acquisition processes, data modeling, process automation, escalation procedures, construction, and deployment.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed 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.
• Monitored project status to meet milestones and resolved issues that might impact on quality or the ability to deliver to timescales or estimates
• Worked in AGILE methodology using SQL Server.
• Design SSAS tabular data model and write reports against tabular model using SSRS and DAX formulas.
• Troubleshoot production, real-time performance and concurrency issues.

Environment: MS SQL Server 2008, SQL Server Data Tools, SSAS,SSRS, T-SQL, Microsoft Visual, SQL Scripts, Linux Scripting (BASH, CSH), Linux Operating Systems, DAX,Visual Basic, Stored Procedures, SQL Profiler, MS Project, MS Access, MS-Excel, Visual Studio

Confidential, Charlotte, NC

MS SQL Server Developer/ BI Developer

Responsibilities:

• Identified data source and define data source Views.
• Design ETL packages from different sources and loaded data to target destination by performing transformation using SSIS.
• Developed store procedures to transform data from data warehouse to SQL and load data to fact table
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Created Logical and physical design of data for projects on basis of user requirement.
• Implemented and maintained database performance and tuning
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformations constraints.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Developed report specifications, created and modified reports using SSRS 2012.
• Created OLAP Cubes from the integrated data and generated reports on those cubes.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Worked on error handling a module consisting of data from bank, transactions, currencies, countries, master and static.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Creation of a dynamic schedule and connection to a C# back end using Entity framework..
• Actively involved in Normalization (3NF) & De-normalization of database.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
• Demonstrated Strong experience using the Informatica Suite of Tools - Power Center version 9, Power Exchange version 9, B2B Data Transformation
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Environment: MS SQL Server 2008, SQL Server Integration Services, SQL Server Report Services, SQL Server Analysis Services, Visual Studio,VSS 2005, Erwin 9.0, Informatica, Windows 7, ASP.NET, MS Access.

Confidential, Philadelphia, PA

MS SQL Server/BI Developer

Responsibilities:

• Implemented complex conceptual database design and database architect into SQL Server 2005/2008R2 using various constraints and triggers.
• Thoroughly used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation for the investment data collected. Involved in Index planning and implementation.
• Performed database monitoring and tuning using SQL profiler and migrated data between SQL servers 2005 to SQL server 2008R2.
• Lead the development of automated SSIS packages to extract, transfer, load and convert data from existing data warehouse to reporting database server.
• Converted, loaded and integrated data from Access, Excel, text.csv files and internal database applications including the mainframe with data captured for security applications.
• Developed and optimized SSIS Packages for “Lead Extraction Engine” which mainly involved high level business transformations on the data to produce the desired weekly and summary vendor extracts needed to monitor the overall effectiveness and profitability of profit margin of investments.
• Created high quality reports, dashboards and analytics to meet the needs of various business clients such asOperations, Sales, Customer Service, Finance, and Executives.
• Designed and deployed reports in MS SQL Server environment using SSRS 2005/2008R2 and created Sub-Reports, Drilldown-Reports for the clients.
• Involved in gathering requirements, product and hardware selection, logical and physical design of the data warehouse, data governance, writing the ETL to populate the data warehouse and data marts, MOLAP and Tabular cube creation, and SSRS DAX/MDX based report development
• Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports
• Scheduled Summary Reports, Parameterized Reports and Ad Hoc reports for viewing purposes by the managers for the analysis purpose

Environment: MS SQL Server 2005/2008R2, SQL Server Integration Services, SQL Server reporting Services, SQL Server analysis Services, SQL Profiler,Microsoft Excel, ODBC, Microsoft Visio, and ERWIN

Confidential, River Woods, IL

BI Developer, MS SQL

Responsibilities:

• For this project, wrote SQL scripts and created packages to transfer the data from different systems and altered the process to meet the new business requirements.
• Designed and developed Logical, Physical of the DSR for the DW using Erwin.
• Migrated data from Heterogeneous data Sources (Excel, Flat file, CSV file) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to load underlying data in to the tables from Text files, Excel file and CSV file.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
• Developed Master Child Package using Execute Package Task and Parent Package Variable Configuration.
• Modified the existingSSIS Packages and added more audits and alerts in case of package failure.
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement.
• Created Views and Synonym to reduce complexity of end user.
• Performance monitored and tuned TSQL queries using SQL Profiler and database engine tuning advisor.
• Created Cluster and Non Cluster Index to optimize performance of TSQL queries.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.
• Used SSRS to generate sub-reports, drill down-, drill through-, tabular-, and parameterized reports.
• Scheduled job using SQL Server Agent forSSISPackages and Store Procedure as per requirement.
• Investigated and fixed several issues and proactively suggested new output formats to satisfy the statisticians’ requirements.
• Developed and wrote documents for Stored Procedures,SSISPackages and SSRS Reports.

Environment: Windows Server 2003, SQL Server 2005, BI studio 2005, SSIS, SSAS, SSRS, Microsoft windows XP