SUMMARY:

• Over 7+ years of programming experience as an SQL developer and Data Modeler in Analysis, Design, and Data Modeling in conceptual, Logical and Physical models
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and reporting solutions using Microsoft SQL Server Reporting Services (SSRS)
• Excellent knowledge in Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensional tables.
• Extensive knowledge in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, CTE (Common Table Expressions), Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors to facilitate efficient data manipulation and data consistency.
• Excellent skills in implementing ETL Packages using Data Transformation Services (DTS) and SSIS
• Migrated DTS packages to SSIS and modified using DTS editor wizard
• T - SQL/Stored Procedures on MS SQL Databases; MS SSIS and Reporting Service and legacy Crystal reports
• Multithread Object Oriented Methodology in Software Design Using VB.Net/C#/C++, ADO.Net 2.0
• Experience in using SSIStools like Import and Export Wizard, Package Installation, and SSISPackage Designer
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations
• Experienced in creating, migrating, deploying complex SSIS packages with complicated transformations like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc using SQL Server Integration Services (SSIS)
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Serve experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS)
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Experience in Importing/Exporting Data from various data sources like SQLServer, Excel, DB2 and Flat file using DTS utility
• Proficient in using Quality Center,Team Foundation Server, and Test Manager
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS)andTableau
• Worked in Agile Scrum Methodology with daily stand up meetings
• Active participation in Software Development Life Cycle (SDLC) specifically Waterfall and Agile Scrum methodology
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS
• Excellent hands on experience in creating groups, hierarchies and measures, KPIs
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports using SQLServer Reporting Services (SSRS) based on client requirement
• Expert in creating Ad-Hoc reports, Linked reports, Snapshot reports, Cross-Tab, Conditional, Top N and Sub reports using SQL SSRS
• Proficient in creating Standard Subscriptions and Data driven subscriptions for delivering reports to people internally within the project
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints
• Performed DBA activities of daily backup and failover restore of database, monitoring/scheduling jobs on different production servers using Red Gate tool
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery
• Experience in SQLOptimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor(DTA), DBCC Commands and Query Execution Plans
• Good Documentation skills and use of Jira
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player

TECHNICAL SKILLS:

Databases: MS SQL Server 2000/2005/2008 , MS-Access, DB2, Oracle 8i/9i/10g/11g

OS: Windows 98/XP, MS Windows 7, 8, Unix

Databases: SQL Server, MS-Access, MySQL, Oracle, Teradata, DB2

Languages: T-SQL, PL/SQL, XML, UNIX shell script, Java Script, .Net

Tools/ Utilities: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS ) , SQL Server Management Studio (SSMS), Visual Studio, TOAD, Putty, Import/Export, SQL*LOADER, SQL Developer, CVS, DTS Package, UML, Erwin, Cognos, WinSCP, MS Excel, MS Project, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Berkeley Heights, NJ

SQL Developer

Responsibilities:

• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions
• Participated in daily scrum (Agile) meetings for our team also organized sprint planning, sprint retrospective and sprint demo
• Developed database objects such as Stored Procedures, CTE, Functions, Tables, Triggers and Indexes using T-SQL
• Used various SSIS task such as conditional split, derived column, which did data scrubbing, including data validation checks during staging before loading data to data warehouse and data marts
• Worked on SSIS Packages using SQL Scripts, Execute SQLtask, Slowly Changing Dimension, XML task etc.
• Maintain historical data in data warehouse used ETL to implement the slowly changing transformation
• Used Team Foundation Server (TFS) to manage source code and deployed application on TFS server
• Implemented Team Foundation Server TFS as Version Management for Microsoft Technologies 2012
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance
• ETL through SSIS and responsible for loading Data to DB from different input sources
• Built SSIS packages with EXCEL and FLAT file source with validations to capture any kind of errors in the source.
• Scheduling jobs for SSIS Packages as per client requirement like daily, monthly etc
• Worked on SQL database to create Cubes on SSAS from scratch
• Worked on Problem Solving on CUBES and SSAS projects
• Created Documentation for Change Control after the Task is completed
• Worked on existing SSISPackages
• Worked on SSIS Parameters

Environment: SQL Server 2012/2014 SSRS, SSIS,SSAS Cubes, Visual Basic, .NET, XML, MS Access, Excel, Share Point, JIRA, C#. Net, Agile, Windows, MS Office

Confidential, Philadelphia, PA

SQL Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation
• Worked on store procedures, indexes and tables
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization
• Worked on 2012/2014 SSIS/SSRS for creating reports
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
• Used various Data Flow Transformations like Lookup, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages
• Scheduled jobs for SSIS Packages as per client requirement like daily, monthly etc.
• Deployed SSIS packages for development, UAT and Prod environments.
• 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 for de-duplication of data.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements
• Fixed Production issues and monitoring the whole job process to deliver committed work
• Provided documentation for the packages and scripts and job created for migrated data
• Created SSIS package to Export and Import data from SQL Server to Text and EXCEL files and Configured SQL mail agent for sending automatic emails
• Developed Cognos reports, dashboards and stories
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel

Environment: SQL Server 2012/2014, SSRS, SSIS MDX, Visual Studio, C#, Dot Net, XML, MS Access, Excel, Share point, JIRA, EXCEL, Windows, Cognos, MS Office

Confidential, New York, NY

SQL Developer.

Responsibilities:

• Performed Migration of SQL Server 2005 to SQL Server 2008
• Generated Logical and Physical Data Models using Erwin
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions by writing complex queries and joins
• Migrated Stored Procedures from 2005 to SQL Server 2008 to refer to Dynamic Management Views
• Created and Deployed of Ad-hoc and Customized Reports to satisfy business needs using SSRS
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly
• Used SQLCMD utility in command prompt to access SQL Server
• Deployed SSIS Packages to the MSDB as well as File System depending on the requirements
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe.
• Maintained all the SQL documents include installation and data conversion Procedure documents
• Monitored Indexes, file growths and analyzed blocking & locking issues to remove the performance bottlenecks

Environment: MS SQL Server 2005/2008, ER-WIN, windows 2003/2005 platform, T-SQL, Excel, Access, Tableau and Windows NT, DTS, SSIS, SSRS

Confidential, Bloomington, IL

Data Modeler/Oracle Developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Involved in Data Modeling and Data Warehousing Using Multi Dimensional Model, Star and Snow Flake Schemas
• Created DDL's for tables and executed them to create tables in the warehouse for ETL data loads
• Assisted ETL Developers in writing their ETL logic for table's population
• Created SSIS packages to load data into SQL Server using various transformations in SSIS
• Analyzed existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse
• Created and Managed OLAP Cubes using SSAS and created different KPIs to perform analysis based on business requirements
• Worked with SSAS cubes using multiple dimensions, perspectives, hierarchies, measures groups to analyze marketing efforts and prospective customers
• Created Tabular Models judging by the data volume and corresponded with Microsoft BI tools
• Identified the dimension, fact tables and designed the data warehouse using star schema
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS)
• Applied OLAP functions to calculate metrics
• Worked on MicroStrategy enterprise manager and Integrity manager
• Worked on the performance tuning of the MicroStrategy reports
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling
• Developed Aggregations, partitions and calculated members for cube as per business requirements
• Defined appropriate measure groups and KPIs & deployed cubes
• Developed .NET PO translation Scheduled Service
• Developed SSIS in data table purging
• Developed outlook adding for automation in PO FTP system
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports
• Created report snapshots to improve the performance of SSRS
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it
• Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures

Environment: SQL Server 2005, Windows 2000/2003, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQLProfiler, MS Excel 2003, MSIIS, Visual Studio 2005, Visual Team Foundation Server, Crystal Reports, .net WCF, WPF and MS Office automation