PROFESSIONAL SUMMARY:

• Over 9+ years of IT experience in the Analysis, Design, Development, Implementing and Testing, Administrating Client/server applications
• Around 8 years’ experience in MS SQL Server 2012/2008R 2/2008/2005/2000 and hands on experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling using Erwin, MS Visio
• Strong understanding of the principles of Data warehouse using Fact Tables, Dimension Tables and star schema modeling and data modeling for ODS
• Strong working experience on Data Warehousing applications. Directly responsible for the Extraction, Transformation and Loading (DTS/SSIS) of data from multiple sources into Data Warehouse.
• Excellent in High Level Design of ETL DTS Packages & SSIS(DTSX) Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all
• Expertise skill in Migrating/Re - writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS)
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL)
• Experienced T-SQL programming skills like creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Data Import/Export, Triggers, and Cursors
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance
• Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Having good experience in creating, modifying, using and debugging Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency
• Experience in performance tuning in SSIS packages by using row transformations
• Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, Drill Down, Drill Through and Cascaded reports
• Experienced in developing Custom Report and different types of Chat Reports, Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server2005/2008 Reporting Services (SSRS)
• In-depth knowledge in Tuning SQL Queries and improving query performance.
• Experience in creating Jobs, Alerts, SQL Server Agent, and scheduled SSIS Packages
• Hands on Experience working of Data quality Services like profiling, cleansing and Auditing.
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio(SSMS)
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS), Tortoise SVN as a tool for repository of codes and version control, branching and merging into production
• Proficient with automated testing tools - Win Runner, Load Runner and QTP for testing Client /Server and Web based applications
• As a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team

TECHNICAL SKILLS:

MS: SQL Server 2012/2008R 2/2008/2005/2000, Oracle 11g/10g/9i/8i, MySQL and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), SSMS, OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal Reports, Power BI

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7, UNIX

T: SQL, PL/SQL, HTML, C#.Net,VB

Design Technologies/Tools: Erwin r7/r4, MS Visio 2007/2010, Rational Rose

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, SSAS, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE:

Confidential, White Plains, NY

Datawarehouse Developer

Roles and Responsibilities

• Worked in migrating data from Misys database to NextGen database.
• Understood dataflow and created a parallel process to integrate data from both processes.
• Worked closely with users for day to day issues from every practice and made required enhancements or developments.
• Used Planio for project management and for better understanding of enhancements\issues.
• Worked closely with SME's to understand domain knowledge.
• Used SQL server agent to schedule jobs on a daily, weekly and specific day of the month basis.
• Understood the process how Microstrategy reports are generated from old application and designed process to merge data from new application into the reports data flow.
• Worked on Informix database for creating source queries and stored procs to import data into sql server.
• Deployed all database objects using Red gate SQL data compare tool.
• Created multiple crosswalk tables for smooth flow of integrating data from two different applications.
• Assisted different teams throughout the organisation in research and analysis of data from the dwh perspective.
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to different environments (System Integration Testing, User Acceptance Testing and Production Environment) from Development Environment.
• Used SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers
• Optimized the performance of various SQL stored procedures using SQL profiler to improve the latency of reports.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Was the only datawarehouse developer taking care of full flow of the data from the warehouse to Reporting data to users.

Environment: Microsoft SQL Server 2012, Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Excel, MS Word, SQL profiler, Windows, Microsratetgy, Planio

Confidential, New York, NY

Sr.SQL Developer

Roles and Responsibilities

• Worked on a database for Centralized Marketing and Analysis users to analyse the sales of the Confidential terminals through various Marketing strategies.
• Worked in Agile Environment reporting day to day activities to the scrum master and used JIRA for creating Epics and stories.
• Involved in gathering requirements from the user, development, testing, deployment and scheduling jobs.
• Worked closely with SME's to analyze the dataflow, ETL and document the process flow of the project for every respective Subject areas.
• Involved in designing the stored procedures to import data from various data sources using Linked servers and bulk imports using SSMS.
• Created tables, Views, Indexes, schemas, file groups, cursors, constraints and User defined functions and triggers to maintain referential integrity.
• Designed SSIS packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, Derived Column, Data conversion, Aggregate, Conditional Split, SQL task, Script task and Send mail task.
• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data during transferring and archived data files from different DBMS.
• Used Execution plan, SQL profiler and Database Engine Tuning Advisor to optimize queries and enhance performance of databases.
• Created SSRS reports using Report parameters, Drop-down parameters, Multi-valued parameters, Matrix reports and Charts.
• Created test cases to check the quality of data for all my developments and enhancements.
• Generated and formatted Reports using Global variables, Expressions and Functions for the reports.
• Designed Meta configuration tables to ingest tables from various data sources and flat files into the data warehouse.
• Designed and developed UNIX scripts and stored procedures to dump the data from tables in UNIX server into flat files and copy them to the database servers (Consumers).
• Worked with different teams in internal systems on where to get the data from to ingest into our database based on the requirements from the Business Users.
• Used GIT and SVN as control repositories.
• Involved in all parts of database migration from Microsoft 2008 to 2014.
• Reverse engineered the inputs and outputs for the whole Dataflux matching process by creating mapping document and submitted to the other team so that they can come up with a similar tool.
• Worked on PowerShell scripts to rename the delivered files, sort them and move to the different processing folders.
• Developed stored procedures and SSIS packages for data import, data cleansing and data selection of the data.
• Responsible to fulfill the project requirements by resolving existing issues to the satisfaction of the Business Users.
• Designed and created Report templates, bar graphs and pie charts based on the financial data and involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval and troubleshooting OLEDB and ODBC connections.
• Used TIDAL scheduler for creating Job groups, scheduling daily and weekly jobs, Email alerts

Environment: MS SQL Server 2014/2012/2008 R2, SQL Server Integration Services (SSIS), SSAS, SQL Server Management Services(SSMS), Tidal, Visual studio 2008/2005, SQL, SVN, XML, Erwin r7, Windows PowerShell, JIRA, Phabricator, UNIX Scripts

Confidential, Ramsey, NJ

Sr SQL Server/BI Developer/Admin

Roles and Responsibilities

• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application SME’s.
• Created and maintained various databases for development and testing environment using SQL Server
• Designed, reviewed, and created primary objects (Tables, Functions, Procedures, views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Maintained the consistency of data by performing data profiling and cleaning mechanisms, possible transformations
• Worked on various tasks and transformations like Execute SQL Task, DFT, Execute Package Task, Conditional split, Script Component, OLEDB Command, Row Count, DCNV, Unpivot, Merge and Lookup while loading the data into Destination
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008 R2/2012
• Created SSIS Packages for Incremental Loading, slowly changing dimensions, data Importing, Cleansing, and Parsing etc
• Used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, and Log Providers etc.
• Deployed the SSIS Packages from development server to production server
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS)
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosstabs and charts
• Involved in writing T-SQL stored procedures, functions for generating various customer review SSRS reports.
• Updated database statistics, Re-indexed and fine-tuned of database objects and server
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability
• Created daily and weekly jobs to restore databases from production to test environments.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
• Worked with QA team to determine if applications fit specification and technical requirements. Tests and evaluates systems, subsystems, and components
• Provided 24/7productionsupport for the production database and also to the code deployed into the production environment

Environment: MS SQL Server 2012/2008R2, SQL Server Reporting Services (SSRS 2012/2008), SQL Server Integration Services (SSIS), SSAS, Business Intelligence Development Studio (BIDS),Tableau, Visual studio 2008/2005, Oracle 11g, SQL, TFS, XML, MS Visio2007, Erwin r7

Confidential, Wilmington, DE

SQL Server BI Developer/DBA

Roles and Responsibilities

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
• Meeting with end user, collecting requirements and converting into technical specifications
• Created Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers
• Created tables, views, users, logins, indexes (indices), check constraints and business rules using T-SQL and maintained databases
• Fine Tuned Data Warehouses including the creation of materialized views, bitmap indexes and partitions
• Used SSIS Packages to extract transform and load data from multiple input sources like Excel files, Production SQL Servers into SQL Server Staging Database
• Used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, and Log Providers etc.
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Implemented SSIS transformation like Lookup transformation, Derive Column, Conditional Split, Merge Join, OLEDB Command, and Row Count
• Implemented Event Handlers and Error Handling in SSIS packages
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2
• Involved in writing T-SQL stored procedures, functions for generating various customer review SSRS reports.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Optimize queries using SQL profiler and Database engine tuning advisor.
• Created OLAP Cubes, Facts and Dimensions for providing summarized and aggregate views of large sets of data and used Multidimensional Expressions (MDX) to access them.
• Worked with QA team to determine if applications fit specification and technical requirements. Tests and evaluates systems, subsystems, and components
• Resolved and closed the Production tickets generated due to failure of daily incremental production jobs and provided on call support for Production issues
• Responsible for Creating Technical Specification document and Process Flow document
• Responsible for drafting, documentation for describing the metadata and writing technical guides

Environment: MS SQL Server 2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), TSQL, SQL *Profiler, Team Foundation Server (TFS), Windows

Confidential, Victoria, TX

SQL Server Developer/DBA

Responsibilities:

• Created Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers
• Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data
• Worked with installing, designing and managing MS SQL Server 2005.
• Worked with Installation/Management of MS Team Foundation Server and TFS Migration processes
• Upgraded DTS packages to SQL Server Integration Services (SSIS)
• Created Tabular Reports, Matrix Reports, Chart and Graphs reports based on business requirements using SSRS
• Created daily and monthly reports in MS-Office Access, MS Excel and Crystal Reports
• Created indexes to improve the performance of the queries
• Performed backups and restore operations
• Used SQL Server Integration Services (SSIS) to perform bulk insert operations from SQL Server 2005 databases to flat files/CSV files and vice versa.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Developed and implemented the application code in Oracle PL/SQL and Microsoft T-SQL
• Formatted the report layout for the requirement of the end users using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Developed Queries for generating drill down, drill through reports in SSRS 2005.
• Identified and defined Fact relationships in SSAS, Created cubes, dimensions, KPI, Measures and calculations.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler and Index Tuning Wizard.
• Used query analyzer to write several DBCC commands and perform database performance tuning.
• Performed job scheduling to ensure execution of certain jobs and daily updates.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, SSRS, SSIS, Windows Server 2003, Oracle 9i, Erwin r4, OLAP, XML, Quest Performance Analyzer and Quest Lite Speed backup tool.

Confidential

Software Engineer

Roles and Responsibilities

• Gathering and analyzing the end user requirements
• Design of user interface screens according to the low level design documents
• Coding in VB6.0, unit testing, integration testing
• Writing SQLs to use in application development
• Writing database stored procedures and triggers to as specified in low level design
• Reporting to project manager

Environment: Visual Basic 6.0, Visual Source Safe, Windows 2000 operating system, Microsoft SQL Server 2000 server, Microsoft Excel, Microsoft word