SUMMARY

• A results driven software professional with 8+ years of progressively responsible experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2012/2008R2 /2008/2005, SSIS, SSRS and SSAS.
• Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.
• Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, physical,logical database design and Performance tuning.
• Experience in Query tuning and performance tuning using SQL Profiler, Clustered and Non-Clustered indexes on tables for faster query retrieval.
• Strong knowledge of Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, and implementation. Provided End User Training and Support.
• Installed, Configured & Deployed Greenplum (Postgre)Databases with Aqua Administration interface
• Developed custom SSIS Packages with C#, VB logic in SSIS Script task and Script Component.
• Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, Conditional Split, Derived column, file system task, row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task and so on.
• Having good knowledge on Hadoop Ecosystem and Teradata DBA .
• Worked as liaison between traders, developers, project manager and process/product analyst to understand the business processes and identified enhancements.
• Developed and provide support on Pentaho Kettle ETL jobs and also migrate the Pentaho Kettle jobs to Talend.
• Expert on creating Score Cards, Metrics, Power View/MAP and PivotTables using Office 365
• Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Studied the existing OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.
• Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
• Expert in creating reports with Charts, Gauges, Table, Matrix, Images, Map, Indicators and so on.
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
• Hands on Experience working with Azure Data Lake Analytics to analyze the structured, non-structured data from various sources.
• Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA LAKE ANALYTICS.
• Worked on creating Azure Data Factory for moving and transforming the data.
• Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations
• Experience in Migrating databases from SQL 2008 R2 to SQL 2012.
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.
• Experience in Agile methodology and implementation of enterprise agile practices

TECHNICAL SKILLS

Databases: Confidential SQL Server (2005/2008/2008R2/2012), Oracle 8i/9i, Oracle 10g/9i DB2,Postgre MS Access, NoSql Databases(Hbase).

Database Tools: MS SQL Server (2005/2008/2008R2/2012), MS-Access, SQL Server Integration Services(SSIS), Data Transformation Services(DTS), SQL Server Reporting Services(SSRS)

Development skills: T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Power BI

Languages: VB.net, Linux, Unix

ETL Tools: DTS, SSIS (SQL Server Integration Services), Informatica, COMOS, Kettle

Reporting Packages: SQL Server Reporting Services, MS Excel.

Tools/Methodologies: MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall.

Operating Systems: Windows XP, Windows 7,Windows 8, Win 2003/2008/2008R2

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Sr.SQL Server BI/Power BI Developer

Responsibilities:

• DevelopedPowerBImodel used for financial reporting of P & L and Headcount.
• Expertise in writing complex DAX functions inPower BI and Power Pivot.
• AutomatedPowerQuery refresh usingpowershell script and windows task scheduler.
• Used various sources to pull data intoPower BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Developed Data Modeling In power bi Desktop handling Star schema, Snowflake Schema and also multiple fact table’s scenarios.
• Deployedpowerpivot model to SQL server Analysis services tabular instance.
• Created reports using, Pie charts, Column chart, Scatter chart, Slicers, KPI, and Table Matrix.
• Worked on monthly reports by using KPI Performance indicators to check the performance on sales and progress.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Shared all the report dashboards and datasets tpo eather.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data intopowerpivot model.
• Documented the entire workflow and processes involved in the Financial ReportingPowerBI Solution.
• Handled Finance close week reporting activities.
• Worked on Azure Data Lake Analytics with Azure Data Lake Store for providing the highest level of performance, throughput, and parallelization of big data workloads
• Integration of Data by Orchestrated ETL pipelines, Profiling, SCD, with SQL, SSIS, Azure Data Factory.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Successfully implemented indexes on tables for optimum performance.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Created Pentaho Jobs and transformations to load data from CSV, Excel files to MYSQL database
• Developed and provide support on Pentaho Kettle ETL jobs and also migrate the Pentaho Kettle jobs to Talend.
• Created DAX and VB scripts for Excel reporting and calculated members
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Creating data blending in case of merging two different datasets using Tableau
• Involved in deployment of SSRS reports on the Share Point Portal.
• Created Datasets in T-SQL, stored procedures for SSRS.
• Extensively used COSMOS ticketing software for working on RFC's sent by the Database SME's.Created Dashboards in SSRS 2008.
• Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.
• Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Developed SSIS Packages with customizing C#, VB logic in SSIS Script task, Script Component to customize data transformation for Error Handling and abstracting file name component.
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Deployment and Scheduling the package in various environment me.e. Dev, QA, Production.
• Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
• Configure SSIS Packages with xml configuration.
• Deploy the package with msdb and file system deployment method.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Created Ad-hoc reports, data driven subscription reports by using Report Builder.
• Created Reports using Charts, Gauges, Tables, matrix.
• Configuring Reporting Service with Share Point Integration as Company Need.
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down Reports, Drill Through Report by Region.

Environment: Power BI, SQL Server 2012, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler

Confidential, Seattle,WA

SQL Server BI/SSIS/ETL Developer

Responsibilities:

• Highly responsible for data transformation from various formats to company’s format on a weekly basis. Managed external client project contracts from technical consultation to delivery of projects
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed logical and physical data models for schemas using Erwin.
• Installed MS SQL Server 2008R2 and Management tools using SQL Server Setup Program.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Helped to designed all kind of production and sales reports for Sales and procurement departments using SSRS
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Developed SSIS Packages with customizing C#, VB logic in SSIS Script task, Script Component to customized data transformation purpose.
• Worked for the department that handles the Mortgage services
• Generated periodic reports based on the statistical analysis of the data using SQL server Reporting service (SSRS).
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion, conditional split and aggregate for creating SSIS ETL Solution..
• Handled slowly changing dimensions to maintain the history of the data.
• Used SQL PLUS programming to write stored procedures, queries, triggers, objects, and views on normalized database tables
• Produced SSRS 2008 reports for State wide reporting.
• Configure SSIS Packages with xml configuration.
• Deploy the package with msdb and file system deployment method.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS for Different Regional Sales Head by Monthly and Quarterly Report.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.

Environment: Windows 2003 Server, SSIS, SSRS, SSAS, Pentaho SQL Server 2008R2, MS Access, T-SQL, Crystal Reports, MS Word, MS Excel, MS Power Point, MS Visio, Visual Studio 2008

Confidential, Florida

SQL Server BI/SSIS/ETL Developer

Responsibilities:

• Gatheird business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Installed and configured MS SQL Server 2008 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created OLAP cubes and dimensions for the analysis of specific areas using SSAS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2008.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Designed high level ETL architecture for overall data transfer from the OLTP/OLAP with the halp of SSIS.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2008 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Established backup and recovery of MS SQL server 2005 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Environment: MS SQL Server 2008, SSAS 2008, SSRS 2008, SSIS 2008, T-SQL, Visual studio 2008, DTS, Data Analyzer, MS Access, Word, Excel, SQL Profiler, Windows XP, Erwin v4.2, Version One

Confidential

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Designed, deployed, and maintained various SSRS Reports in SQL Server 2005
• Created Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports
• Actively participated in gathering Business Requirements that are focused on providing a user friendly System usage or ambience
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format
• Created SSIS packages to download data from FTP sites and populating into different databases and tables.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008R2
• Optimized the query performance with modification in T-SQLqueries, removing unnecessary columns, eliminating redundant and inconsistent data.
• TEMPEffectively created and used views in SQL Server to prevent unauthorized access
• Performed tuning of databases by normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Developed and created the new database objects including tables, views, indexes, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer
• Worked on complex data loading (implemented the batch data cleansing and data loading
• Meeting with Business Analyst and data modelling team to understand requirements and existing
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard
• Data conversion from Text File into SQL Server Table and Database recovery and database maintenance plan
• Assisted in designing and implementing database logical and physical schemas and document the testing and maintenance of system corrections

Environment: SQL Server 2008R2, SQL Services Integration Services 2008R2, T-SQL, XML, MS SQL Reporting Services 2008R2, SQL Profiler, MS Office, DB2, Windows Server 2008.

Confidential

SQL Developer

Responsibilities

• Involved in system analysis & design of the Enterprise data warehouse implementation, Requirements gathering and understanding the business flow.
• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Creating Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.
• Creation of database tables and procedures to update and clean the old data.
• Transferred data from flat files, Excel spreadsheets, and XML Source data to SQL Server using SSIS and also used BCP and Bulk Insert.
• Designed dashboards, including scorecards and reporting with the Dashboard Designer delivered via MOSS ( Confidential Office SharePoint Server).
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created, Maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, and Master Reports & Parameterized Reports, Drill Down Report, Drill Through Report usingSQL Server Reporting Services SSIS 2005.
• Proficient on and designing Data Mart and Data Warehouse using Erwin in Star and Snowflake Schemas.
• Helped Database administrators with power shell in building robust administration scripts.
• Responsible for support of MOLAP structures using Analysis Services 2005 and reporting structures in MS EXCEL and Reporting Services 2005.
• Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2005.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.

Environment: Confidential SQL Server 2005, MS Access, SSIS, SSRS, Query Analyzer, ERWIN, Windows server 2003, DTS, T-SQL, SQL Profiler, DTS