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 the use of triggers and SQL Scripts.
• Extensive experience in Tuning SQL queries and improving the query performance.
• Experience in Dimensional Modeling, ER Modeling, Star /Snowflake Schema, FACT and Dimensional tables.
• Experience in optimizing the 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 Tools: Internet 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 the front end requirement and commercial transitions, writing triggers, creating user defined functions, and creating views to simplify the 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 the migration purpose and worked on optimization of the queries for better performance.
• Used SSIS jobs and packages using the 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 the 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 the 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 help 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 the 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 the Enterprise data warehouse implementation
• Created various database tables and procedures to update and clean the old data.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Created and designed the data warehouse and core Database for the system including various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors, User Defined Functions and triggers to implement the 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 the architecture of databases, creation & indexing of the 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 then 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 the 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 the 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 the 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 the data using SSIS (SQL Server Integration Services) packages.
• Used MS Excel, CSV files as data source and copied data to the target.
• Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database.
• Generated Reports in SSRS using Expressions and Functions for the 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 the subscription reports with the subscription report wizard.
• Created SSIS packages to import the data into SQL server and troubleshoot the 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:

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

Confidential 

SQL Server Developer

Responsibilities:

• Actively participated in gathering of User Requirement and system specification.
• Developed stored procedures, views and User Defined Functions using T-SQL statements.
• Involved in creating clustered and Non-clustered Indexes to improve the database transactions performance.
• Maintained the table performance by following the tuning tips like Normalization and creating indexes
• Worked on importing /transferring the data to database tables using DTS, Import and Export Utility.
• Created and automated regular jobs Daily/weekly Report Generations.
• Monitored Performance and optimized SQL queries for maximum efficiency.
• Support for Database programming related issues.

Environment: Windows Server, SQL Server 2005, Query Analyzer, Enterprise Manager