SUMMARY:

• Over 7+ years of in - depth experience in database Design, Modeling, development of SQL Server 2012/2008R large scale databases.
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Experience in Power BI
• Worked as an ETL Developer using informatica software tool designed to simplify Data Warehouse design and routine tasks related to data transformation and migration.
• Ample experience in MDM, DQS
• Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Experience in Management of Data governance
• Experience with T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and working knowledge of Analysis Services (SSAS).
• Assisted in development of ETL architectural standards and provided guidance and conducted trainings to Architects.
• Crystal Reports development focusing on website/email tracking, database queries and accounting.
• Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, Access) and power pivot.
• Launching the report builder for adhoc reports.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Implemented different Replication Models like Snapshot, Merge, Transactional and Database Mirroring.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML, MDX and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Good Knowledge in designing Database Models using UML, MS Visio and Erwin.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member

TECHNICAL SKILLS:

RDBMS: SQL Server 2005/ 2008/2008 R2/ 2012/2014, DB2

Database/ETL Tools: SSIS, SSAS, SSRS, Informatica Cloud, Microsoft Azure

Reporting: SQL Server Reporting Services (SSRS), Report Builder, Cognos, Tableau

Languages: VB.NET, C#, C++, T-SQL, E-SQL

MS-Office: Microsoft Office Tools

Operating Systems: Windows Server 2000, 2003, 2008, 2008R2, 2012

Tools: Backup Utility, Lite Speed for SQL Server, Visio

PROFESSIONAL EXPERIENCE:

Confidential - Bridgewater, NJ

SQL Server SSIS /SSRS Developer

Responsibilities:

• Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes
• Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements. And prepared documentation for same.
• Worked as an ETL Developer using informatica software tool designed to simplify Data Warehouse design and routine tasks related to data transformation and migration.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS.
• Experienced in MDM, DQS
• Experienced in Power BI
• Work on SQL Server Integration Services (SSIS) to extract data from various sources (Flat files, Excel, Oracle DB2, & SQL Server)
• Updated functional specification and technical design documents.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Analyze existing ETL jobs and find the gaps
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Designed an OLAP system with the help of ERWIN to visualize data structure.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2008/2014.
• Create low level design and ETL design doc according to requirement.
• Generated daily, weekly and monthly reports using SSRS 2008/2014.
• Served as a SSRS 2008 Reports Developer and SQL Server Developer in support of Service Management System.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS using Visual Studio 2010.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Environment: SSIS, SSRS, MS SQL Server 2012/2014, 2008, R2/2005, C#, SharePoint, Visual studio 2008/2010, MS Access, MS Excel, MS Office Access 2007

Confidential - Bowie,MD

MS SQL Server/BI Developer

Responsibilities:

• Worked as a database developer on databases like MS SQL Server using T-SQL, stored procedures and views to get data from Data warehouse.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Worked as an ETL Developer using informatica software tool designed to simplify Data Warehouse design and routine tasks related to data transformation and migration.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server
• Made Master Child package using variables and Execute package task in SSIS. and transformations that SSIS provides.
• Deployed, Tested and Scheduled SSIS packages.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Leading and mentor the efforts of data quality completeness initiative for Informatica based ETL architecture.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Developed incremental loading using MERGE statement in SQL and also used slowly changing dimension (SCD).
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Used Execution Plana and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.

Environment: Windows Server 2003, SQL Server 2012/2008R2, SharePoint, SQL Profiler, Microsoft Visual Studio 2008, SSIS, SSRS,VB.Net.

Confidential

MS SQL Server SSIS / SSRS Developer

Responsibilities:

• Requirements gathering, Analysis and Design of all the clients(support offices, donors and sponsors) requirements.
• Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to sql server.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc. to migrate the old Bills information, Customer Information, Contracts Information and other important data.
• Used Crystal Reports to tracked logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data Source and defined them to build the Data Source Views.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.
• Managed Alerts for successful or unsuccessful completion of scheduled Jobs.
• Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click-through and demographical comparisons with SQL database of customer information.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in testing, bug fixing and documentation for the project.

Environment: SQL Server 2008, SQL BI Suite (SSIS, SSRS), T-SQL, SQL Profiler, MS Office, Erwin, Windows Server 2003.