SUMMARY

• Over 7+ years of experience in IT as MS SQL Server Developer / Data Analyst working in various domains in 2012/2008R 2/2008/2005/2000 Windows Environment.
• Extensive experience in T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) creating Design, Development, Testing, Implementation and Production/Support phases of SDLC for Data Warehouse, Client/Server, RDBMS and Web Based Application working in Agile, Waterfall, RUP environment.
• In-depth experience of Transact-SQL (DDL and DML) operations.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experience in implementation of strong referential integrity by teh use of triggers and SQL Scripts.
• Extensive experience in Tuning SQL queries and improving teh query performance.
• Experience in Dimensional Modeling, ER Modeling, Star /Snowflake Schema, FACT and Dimensional tables.
• Experience in optimizing teh database by creating various Clustered, Non-clustered indexes.
• Expert in Database Normalization, DE normalization, Optimization and Tuning, Backup/Restore, Data Import/ Export, Troubleshooting, and Database Objects authorization.
• Experience in designing Database Models using MS Visio and Erwin Data Modeler.
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Data Transform Services (DTS), Bulk Insert, BCP.
• Experience in building robust Architecture to organize Data flow from various homogeneous and heterogeneous system using SQL Server Integration Services (SSIS) and Data Transform Services (DTS).
• Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS and SSIS Packages.
• Expert in creating Chart reports, Drill down and Drill through Reports by passing parameters in SQL Server Reporting Services (SSRS).
• Good experience in Developing and Extending OLAP Cubes, Dimensions and data source view and designing, creating, processing of cubes using SSAS.
• Experience in using SSRS (SQL Server Reporting Services), SSAS (SQL Server Analytical Services) objects and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).
• Expert in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
• Proficient in conducting System and Functionality Testing, Regression Testing, User Acceptance Testing (UAT).
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

RDBMS / Databases: MS SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 10g, 11g, MS-Access 2007/2003

Languages: T-SQL, PL/SQL, .NET, Visual Basic 6.0, HTML

Operating Systems: Windows Server 2008/2003/XP/2000/NT/98/95, MS DOS 6.2

Modeling Tools: Microsoft Visio 2007, Erwin Data Modeler 8/7/5

Reporting Tools: Crystal Reports 8/10, SQL Server Reporting Services (SSRS)

Integration Services: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Analysis Service: SQL Server Analysis Services (SSAS)

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCPOLAP, ADO.NET, Database Engine Tuning Advisor (DTA), Internet ToolsInternet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP

SharePoint: Microsoft SharePoint 2003 - 2010

PROFESSIONAL EXPERIENCE

Confidential, New Rochelle, NY

SQL BI Developer/ Data Analyst

Responsibilities:

• Involved in complete life cycle of database including designing of database, populating look up data, creating stored procedure as per teh front end requirement and commercial transitions, writing triggers, creating user defined functions, and creating views to simplify teh complexity of data structure.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created complex T-SQL queries and stored procedures for teh migration purpose and worked on optimization of teh queries for better performance.
• Used SSIS jobs and packages using teh complex queries and stored procedures to do file operation and to apply business rules.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
• Used Query Optimization and SQL Server Profiler for troubleshooting, Monitoring, tuning report queries and improved performance in SQL Server.
• Involved in running Trace from teh Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Maintained databases, performed software installations and upgrades, monitored Database Performance by implementing automated backup and database maintenance / cleanup jobs.
• Developed and Extended SSAS Cubes, Dimensions and data source viewing and Deploying and Processing SSAS objects.
• Delivered business intelligence to halp sales and marketing team maximize ROI for campaigns by providing reports and recommendations, which requires strong analytical skill, problem solving skill.
• Monitored company performance and assisted management to make business decisions by generating ad-hoc reports, inventory reports, commission reports, etc.
• Collaborated with cross-functional teams including sales, marketing, editorial, production and QA to drive workflow definition, to streamline existing process and to successfully execute on teh roadmap.

Environment: MS SQL Server, T- SQL, MS Excel, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio, Erwin/MS Visio

Confidential, Hauppauge, NY

SQL BI Developer/ Data Analyst

Responsibilities:

• Involved in system analysis & design of teh Enterprise data warehouse implementation
• Created various database tables and procedures to update and clean teh old data.
• Actively involved as part of a team for gathering and analyzing teh needs of End User Requirement and System Specifications
• Created and designed teh data warehouse and core Database for teh system including various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors, User Defined Functions and triggers to implement teh business logic.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Performed activities like analyzing and improving teh architecture of databases, creation & indexing of teh tables.
• Provided strategic insights on business/market performance and trends by analyzing & interpreting internal and external data, which requires extensive management consulting experience with enterprise reporting tools Microsoft SQL Reporting Services.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2012 instances and to load into staging and tan to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• 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 teh reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Scheduled and maintained nightly and weekly loads of data by creating teh corresponding job tasks.
• Configured and scheduled packages to be deployed out to a production environment using SQL server Table file configurations in SSIS.
• Configured packages for development, QA and Production environments.
• Created Drill down and drill through reports, multi value parameter reports.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for teh analysis of managers and end users by using SSRS.
• Monitored & interpreted on key business metrics, track traffic source and drove insights on customer behavior, by using Google Analytics (GA) and other digital analytic platform.
• Analyzed and Synthesized information across multiple data source: Google Analytics, Google Trend, Facebook Insight, to provide a clear point of view on marketing campaigns performance such as TV show, Facebook, Banner Ads, Online shop, etc.
• Developed actionable recommendations on digital marketing campaigns, pricing & distribution strategy by compiling and analyzing statistical information from internal and external databases.

Environment: Microsoft SQL Server, SQL Profiler, SSMS, SSIS (Integration Services), SSRS (Reporting Services), Microsoft Visual studio

Confidential, Andover, NJ

SQL Server BI Developer

Responsibilities:

• Wrote complex T-SQL statements, Stored Procedures, functions, view and triggers.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Exceptional communication skills in requirement gathering and design strategies for database management system.
• Developed re-usable stored procedures for database application support.
• Worked with transferring teh data using SSIS (SQL Server Integration Services) packages.
• Used MS Excel, CSV files as data source and copied data to teh target.
• Scheduled jobs using SQL Server Agent for executing teh stored SSIS packages which were developed to update teh database.
• Generated Reports in SSRS using Expressions and Functions for teh reports.
• Designed and rolled out canned and ad-hoc reports.
• Designed drill down, drill through, sub-reports and ad-hoc reports on large scale.
• Responsible for scheduling teh subscription reports with teh subscription report wizard.
• Created SSIS packages to import teh data into SQL server and troubleshoot teh already existing SSIS packages.
• Provided documentation for reports and SSIS packages.
• Worked with a team to suggest automated processes to reduce human errors and also to save time and resources.

Environment: MS SQL Server 2012, T- SQL, Power Pivot, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS), Visual Source Safe (VSS), Erwin

Confidential

SQL Server Report Developer

Responsibilities:

• Gatheird requirements from teh business users, created technical specification documents.
• Defined relationship between tables and enforced teh referential integrity constraints.
• Gatheird teh data from different sources using SQL Server Integration Services (SSIS) 2008 using different transformation, constraints, checkpoints and configuration settings.
• Integrated teh reporting services with MS Share Point while deploying teh reports and implemented teh report subscriptions to run on daily/weekly/monthly basis and email teh results to teh business users in teh required format.
• Worked with SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize teh queries, procedures.
• Added/modified Users, Groups, folders, rights and involved in teh implementation of log shipping, mirroring to maintain teh high availability of teh servers.
• Created/modified SQL Joins, sub-queries, indexes, stored procedures, triggers and other T-SQL, PL/SQL code to implement business rules and automate teh tasks.
• Involved in documenting teh project steps and presenting to teh team members.

Environment: MS SQL Server, SSRS (Reporting Services), SSIS (Integration Services), SSMS (Management Studio), TFS, T-SQL, PL/SQL, Oracle, MS Share Point, Access and Excel.