SUMMARY

• Over 8+ years of strong IT experience with demonstrated success in the Database development, design, Administration and deployment of large - scale enterprise applications.
• Excellent understanding of the Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and role of QA.
• Expert in MS SQL Server 2014/2012/2008 suite of products like SSIS, SSRS and SSAS.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.
• Extensive knowledge in T-SQL queries (DDL and DML) for developing complex Stored Procedures, Batch Scripts, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.
• Extensive knowledge of addressing Performance Issues and involved in Index tuning, Data Profiling and optimized queries using query execution plan.
• Excellent in working on SSIS, SSAS, SSRS, OLAP, OLTP, Reporting and Analytics, Data Cleansing, Data Scrubbing, Data Migration and writing T-SQL.
• Expertise in developing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Experience working with REST API sources in SSIS
• Retrieving data from a Power Pivot workbook that containsthe data behind PivotTables and PivotCharts
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Extraction &Migration of Data from heterogeneous data sources like Excel, MS Access, Teradata, Oracle, AS400, and DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS utilities.
• Experience in Performance Tuning for SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs, alerts and scheduling DTS/SSIS packages in SQL Server Agent on daily/weekly/monthly basis.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Experience in developing Crystal Reports, Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder.
• Experienceingenerating on-demand and scheduledreportsfor business analysis or management decision using SQL Server Reporting Services.
• Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in Performance Point Server that use different types of web parts and excel services for reports.
• Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, and Database Security.
• Expert in gathering business requirements and converting them into technical requirements
• Implement/code reporting and database solutions usingclient standard coding and design standards which include MSSQL queries and stored procedures Implement and test solution architecture.
• Maintain and Monitoring of Various SSRS reports, SQL code, store procedures and Solving Tickets on Daily Basis for Production Issues.
• Plan and design Microsoft SharePoint environments.
• Configure of Microsoft Office SharePoint.
• Create modify and delete SharePoint accounts as directed and in compliance with all standard operating procedures.
• Configure SharePoint services and settings.
• Excellent experience in Functional and System testing with a complete QA cycle from testing, Bug logging, Regression testing and UAT testing.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Experience in providing 24 x 7 production support.
• Excellent communication skills, organizing skills, highly punctual and an excellent listener.
• Proven experience in project and team leading with minimal defect delivery. Equally comfortable working independently as well as in a team environment
• Ability to work in a team and as an individual with minimal supervision.

TECHNICAL SKILLS

Programming Skills: T-SQL, C, HTML, XML, JavaScript, ASP.NET, VB, C#

Databases: Microsoft SQL 2014/2012/2008 , MySQL, SYBASE, MS ACCESS

BI and ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Pervasive Data Integrator, Adept SQL diff, Oracle SQL, Microsoft Visual Studio2010/2012, Cognos 10.2

Reporting Tools: Microsoft SQL SERVER 2005/2008/2012 , Reporting Services (SSRS), Report Builder 2.0, Report Builder 3.0, Crystal reports 10, ProClarity, Tableau

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

Operating Systems: Microsoft Windows, UNIX, LINUX

Tools: and Utilities Business Intelligence Development Studio (BIDS), Visual Studio 2013/2008, Share Point 2013, Team Foundation Server (TFS), Microsoft Word, Excel and PowerPoint

Version Control Tools and Browsers: TFS, Firefox, MS IE 6.0, 7.0, Google Chrome and Safari

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

SSIS/ETL Developer

Responsibilities:

• Designed ETL SSIS packages for loading data files provided by the external vendor into our data warehouse, generating reports for Sales Operations, supporting internal data warehouse applications, and generating Outbound files.
• Created validations for raw data in value centric files, before importing the data to the actual database.
• Created tables in Staging database for importing and processing the data.
• The development technologies involved working with Microsoft SQL Server 2014, SQL Server Integration Services (SSIS), Visual Studio 2012, and TFS.
• Written SQL Queries for Validating the data and deployed the packages in DEV and QA environments.
• Worked closely with Business Analysts, data architects to understand the business requirements, design standards, and for validating all business rules applied in the ETL framework.
• Developed complex SQL queries, Joins, Functions, CTEs, and Stored Procedures to generate reports.
• Implemented SSIS packages to call Salesforce API to load data using Task Factory.
• Designed complex packages include various DFT transformations like Lookup, Fuzzy Lookup, Multicast, Condition Split, derived column, OLEDB Command and Control Flow operations like For-Loop, For Each loop, Sequence Container.
• Implemented Standardizing Addresses for the legacy data in SalesForce by calling Smarty Streets API through REST API.
• Automated Merged Accounts reports on monthly to weekly based using ETL packages.
• Documented ETL packages in development process to assist other teams and for future development purposes.
• Developed Merge jobs in SSISto extract and load data into SQL database.
• Responsible for creating/migrating undocumented SSRS reports.
• Responsibilities involve ETL development, unit tests, business validations, integration tests, defect resolution and production support.
• Worked closely with Business Analysts, data architects for business requirements, design standards, validations, and UAT tests.
• Modified the test cases according to business requirements whenever it’s needed as well as whenever any new release has been delivered.
• Hands on experience in designing PowerShell code for SSIS Project deployments in SQL Server SSISDB, Pivot tables, VLOOKUP validations in Excel
• Had a chance to optimize legacy system SSIS packages, SQL code using SQL execution plan, Indexing, Update Stats and documented ETL packages going through development process to assist other teams for future development purposes.

Environment: SQL Server 2014, SSIS, T-SQL, SSMS, C#, Excel 2013, TFS, Visual Studio 2013, Salesforce, info ERR LN, Cognos

Confidential, Jersey City, NJ

SQL BI Developer

Responsibilities:

• Part of a large technical team, responsible for development of database objects (schema changes, stored procedures implementation) and SSIS packages.
• Understood Brokerage business knowledge and financial products.
• Responsible of analyzing the existing data elements (Client specific schema) and mapping to Confidential specific data elements.
• Worked in Agile based environment involved to work closely with web, Mid-tier, BSA and QA to understand business requirements.
• Responsibilities involve Requirement analysis, Design and prototyping, developing unit tests, bug fixes, maintenance and production support.
• Responsible for adhering to our Programming, documentation and process standards.
• The development technologies involved Microsoft SQL Server 2014, Microsoft SQL Server Integration Services (SSIS), Microsoft Visual Studio 2013, Microsoft Office, XML, Scripting (Visual Basic, C#), and Team Foundation Server (TFS).
• Wrote complex SQL queries using joins, stored procedures, User Defined Functions, Views, Indexes XML Queues
• Wrote complex script tasks in C#, VB script for generating xml message to place into the queue.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all, For Loop, Foreach Loop, lookup, Derived Column and others.
• Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Designed and executed Test Plans and Test Cases, generate Test Scripts and Test Scenarios.
• Conducted ETL Design and prepared ETL design documents/technical specifications- Identify transformation rules using Talend.
• Extracted the data from different Data Sources and transformed the data as per the user criteria and used the data in the SSAS cubes for the analysis.
• Created reports to retrieve data usingStored Proceduresthat accept parameters.
• GeneratedSub-Reports,Drill down reports, Drill through reports, Parameterized reports using SSRS and created various types of reports like chart, tabled, matrix and linked reports and maintained accurate and complete documentation for all packages.
• Created code reviews for DB objects in code collaborator and get them debugged before they check-in into TFS and QA roll out.
• Handling tickets for Database deployments into QA, QFinal and Production Environments
• Worked on various QA and Production Defects.
• Handled multiple tasks, in-depth knowledge in agile environments and worked hard to produce best results.
• Responsible forAnalyzing report requirements and developing the reports by writing Teradata SQL Queries
• UtilizedODBC for connectivity to Teradata via MS Excel to retrieve automatically from Teradata Database.
• Designed & developed various Ad hoc reports for different teams inBusiness (Teradata and Oracle SQL, MS ACCESS, MS EXCEL)
• CreatedMultiset, temporary, derived and volatile tables in Teradata database.

Environment: SQL Server 2014/2012/2008 , SSIS, T-SQL, SSMS, C# scripting, BIDS, Excel 2010, SharePoint 2013, TFS, Visual Studio 2013/2008, Code Collaborator Client, Rally, ServiceNow.

Confidential, Rensselaer, NY

MS SQL Server Developer

Responsibilities:

• Used Workforce Central Management 6.1 version tied the SQL Database to the workforce management by using SSMS and verified the created 120 SSRS reports from user perspective to make sure right amount of data is processed.
• Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
• Worked on RDL‘s of the reports and promoted those RDL’S to WFC portal.
• Troubleshoot SSIS Packages and convert to SSRS Reports.
• Responsible for Debugging reports using Stored Procedures.
• Created Cross-Tab, Drill-down, Drill-through, Parameterized and Sub-Report using RDL.
• Promoted RDLs to Reporting Service Server.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Evaluate current reporting infrastructure to find bottlenecks and recommend improvements.
• Responsible for creating/migrating undocumented crystal/SSRS reports.
• Created and modified efficient Stored Procedure and functions which implement necessary business logic to support the front end application to facilitate pulling data.
• Developed and optimized stored procedures using input, output, table valued parameters and Query Analyzer.
• Create new SSIS Packages to export flat file for customer.
• Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created package to transfer data between OLTP and OLAP databases.
• Assisted front-end C#.NET and ASP.NET developers using Visual Studio 2008 (C#, ASP.NET).

Environment: SQL Server 2008, BIDS, SSIS, SSRS, Crystal Reports XI, Visual Studio, T-SQL, C#.NET, ASP.NET

Confidential

Junior SQL Server Developer| Report Writer/Developer | T-SQL

Responsibilities:

• Migrated the existing database from SQL Server 2008 to SQL Server 2012 and worked on improving the performance of the system.
• Reports are also created for the banking process on the daily and weekly basis. These reports were reviewed by Directors and Analysts to calculate different categories like banking calculation. It also involved in creating new database from different scatter database.
• Gathered requirements and acquired application knowledge from Business Managers.
• Collect functional and application data requirements from customers.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created drill down and sub reports from reporting services (SSRS) that can be browsed on web.
• Worked on relationships and hierarchies between attributes and measure groups and defined granularity with in a measure group and drill through actions in SSAS.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Developed reports using SSRS 2008 mainly parameterized reports.
• Developed report specifications, created and modified reports using SSRS 2008, deployed, and maintained of various SSRS Reports in SQL Server 20012.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard.
• Worked on error handling a module consisting of data from bank, transactions, and currencies, countries, master and static.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Actively involved in Normalization & De-normalization of database.
• Planned a complete backup on the database and restored database from disaster recovery.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Worked on designing ETL packages using SQL Server 2012.
• Used “SQL Profiler T-SQL Duration” template for tracking execution time of T-SQL Statements.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers

Environment: SQL Server 2012/2008/2005 , Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), Crystal Reports, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access, Visual Team Foundation Server, Crystal Reports, TOAD, visual studio 2008, Visual studio 2012, Talend.