SUMMARY

• 6 years of Professional experience in IT industry, mostly in Microsoft BI projects wif extensive usage of ETL & Reporting tools. Worked wif ETL, Business Intelligence, Designing, and Development.
• Expert in MS SQL Server Business Intelligence suite (Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS)).
• Solid experience in designing and creating high data volume ETL SSIS applications for efficiency and maintainability.
• Experience on evaluating existing SSIS packages on SQL 2008 R2 and upgrading them to SQL 2012 SSIS packages.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, and Data Flow Task in Designing packages.
• Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, and sort, data Conversion, Union All, Merge Join, SCD and OLEDB Command to load data into SQL Server destination.
• Maintaining teh Log and Audit information in teh SQL tab Experience in providing Logging, Error handling by using Event Handler for SSIS Packages.
• Expert in creating Dimensions, Cubes, Measures, Calculations, KPIs and MDX Queries using SSAS.
• Expertise skills in Calculating Measures and Calculating Members in SQL SSAS using MDX.
• Experience in building analytical data models using PowerPivot for Excel Add - in.
• Experience in using Tabular Modeling in SSAS.
• Expert in creating SQL server Reports like Drill down Reports, Parameterized reports, Matrix reports and Chart reports using SSRS, and designing report layout.
• Experience in creating Ad-hoc Reports, data driven subscription reports by using Report Builder in SSRS
• Experience in Database design, entity relationship model and application oriented design.
• Data modeling experience focusing on high-activity, normalized transaction systems (OLTP), highly-usable denormalized reporting systems (OLAP) as well as staging areas and data marts.
• Extensive experiences in T-SQL developing Stored Procedures, Views, Triggers, XML and Complex Queries on SQL Server 2005/2008/2008 R2/2012.
• Experience in Performance Tuning, Query Optimization and running Database.
• Working knowledge of SharePoint.
• Involved in teh users (Traders/Financial Advisors/Department Managers) and product support.
• Excellent verbal and written communication skills combined wif interpersonal and conflict resolution skills and strong analytical skills.
• Ability to work independently and in a team environment and actively participate in projects wifin work groups and across organizations

TECHNICAL SKILLS

Operating Systems\Technologies\: Windows XP/7/8/2008R2/2012\ASP.NET\

Programming Languages\Web Server\: C#.NET, C++, T-SQL\IIS 6.0, 7.0\

Web Technologies\DBMS\: HTML, CSS, JavaScript and XML\MS SQL Server 2005/2008R2/2012, MS Access\

BI Software\MS Office Tools\: SQL Server Reporting Services (SSRS), \Excel, Word, PowerPoint, Outlook\

PROFESSIONAL EXPERIENCE:

Confidential, Bridgewater, NJ

MS SQL Server/BI Developer

Responsibilities:

• Actively involved in Business meetings and requirement gathering sessions.
• Provide consultation on SQL Server to development team.
• Create database control file, set database initialization parameters and plan to distributetable spaces across different installation.
• Involved in troubleshooting performance issues and fine-tuning queries and stored procedures.
• Analyze database performance wifSQL Profilerand Optimizedindexes to significantly improve queries.
• Involved in designingOLAPCubes in SSASenvironment using Snowflake/ and Star Schemas.
• Created a number of cubes wif multiple fact measures groups, and multiple dimension hierarchies, critical KPIs using as per OLAP reporting needs.
• Involved in creating and deploying reports using SQL Server Reporting Services 2008 R2.
• Develop SSIS packages to Extract data from Flat files source, transform them and to load them into Transaction stage tables
• Schedule teh SSIS packages through SQL agent jobs.
• Dynamically configure packages to make them environment independent
• Understand teh Business Logic to enable reporting.
• Involved in teh QA process bytesting, bug fixingand also involved in teh documentation for teh project

Environment: MSSQL Server 2008R2 Enterprise Edition, T-SQL, ODBC, Excel, SSAS, SSIS, SSRS, SQL Profiler, Windows 2008R2 Server,IIS 7.0

Confidential, New York, NY

MS SQL Server/BI Developer

Responsibilities:

• Used teh SSIS to migrate Databases such as Oracle and Access database, flat files to centralized IT destination.
• Responsible for Developing, Monitoring and Deploying SSIS packages.
• Implemented slowly changing dimension on 500,000 records dat took 11minutes to complete. Improved teh performance by replacing it wif checksum to 8minutes.
• Successfully created dynamic configuration packages in SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Integrated SharePoint wif SSRS and managed reports subscriptions, delivery, generation, rendering, and sharpshooting via SharePoint User Interface.
• Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by teh clients and advisors based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Developed Report Models using report builder and distributing reports in multiple formats using SQL Server Reporting Services (SSRS) in SQL Server Data Tools (SSDT).
• Conducted performance tuning by using SQL Profiler and index tuning wizard.
• Involved in Creation of Reports of varying degree of complexity.
• Analyzed Business and Technical specifications, developing Use-Case diagrams, Activity Diagrams.
• Created many complex Stored Procedures / Functions and used them in Reports directly to generate reports on teh fly.
• Scheduled, maintained, and supported teh distribution and access to reports through Report Server.

Environment: Windows 7, SQL Server 2012 BI Suite, SSIS, SSAS, SSRS, SharePoint, T-SQL

Confidential, Chicago, IL

MS SQL Reporting Developer

Responsibilities:

• Responsible for database development in SQL Server 2008 R2, worked on T-SQL functions and SQL syntax.
• Responsible for SQL Server performance tuning and troubleshooting.
• Created complex Stored Procedures, User Defined Functions, Triggers, Views, SQL joins, CTE’s and other T-SQL code to implement business rules.
• Transferred data from homogeneous and heterogeneous data sources such as MS Access, MS Excel, Flat files, and CSV files into SQL server.
• Designed (SSIS) SQL server integration packages by using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, and migrated data using various complex transformations such as Derived Column, Lookup, Bulk Insert, SCD and Merge Join.
• Designed and maintained various types of reports basing on teh requirements using SSRS.
• Involved in Deploying reports to report manager and trouble shooting for any errors occurred in deploying.
• Generated various report models on views (due to security issues) and deployed them on to teh production reporting server and generating ad-hoc reports.
• Involved in monitoring performance, tuning and optimizing SQL queries for maximum efficiency.
• Formated teh reports using teh Global variables and expressions.

Environment: MS SQL Server 2008 R2, MS SQL Server Integration/Reporting Services 2008 R2

Confidential, Urbana, IL

MS SQL Server/BI Developer

Responsibilities:

• Involved in End to End development right from Design, Development, Implementation till Testing.
• Designed and developed Star Schema for Finance (Revenue breakdown by all parameters), Marketing (Sales report by all parameters) and Customer Service departments.
• Developed various reports using SSRS.
• Set up Month End and Day to Day Financial reports like AR, Profit and Loss and Revenue reports.
• Designed and implemented plans to migrate large databases.
• Involved in Normalization, tuning, optimization, auditing and archiving of teh SQL Server database.
• Analyzed teh three-tier Application architecture and process flow.
• Analyzed teh Application-security.
• Collaborated wif software engineers, architects, and technology specialists to design database, clustering, and migrations.
• Developed, implemented and monitored a large-scale and time-sensitive production loading processes.
• Developed and implemented replication, archiving and backup and recovery strategies.
• Proactively monitored teh production database and optimizing stored procedures for better performance. Resolved locking conflicts and resource utilization.
• Administered, maintained, developed and recommended policies and procedures for ensuring teh security and integrity of teh company's databases.
• Managed and created database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc.).
• Ensured dat all database environments (Development, Staging, QA and Production) are in sync.
• Problem solving and issue resolution on production SQL stand alone and cluster databases.
• Designed, reviewed and implemented production SQL Server database objects, models and database designs (schema).
• Identified and resolved database performance issues, database capacity issues and other distributed data issues.

Environment: SQL Server 2008 R2, .Net, SSIS, SSRS, SSAS, Star Schema, VBA, SQL Stored Procedures, T-SQL, Data warehousing, Enterprise manager, Query Analyzer, MS Power point

Confidential

MS SQL Server/BI Developer

Responsibilities:

• Involved in teh full life cycle of dis project (Analysis, Design, Implementation, Testing and Maintenance).
• Designed and developing SSIS, SSRS, Star Schema.
• Involved in Designing, normalization, tuning, optimization, auditing and archiving of teh SQL Server database.
• Analyzed Stored Procedures.
• Maintained 15 databases.
• Involved in Product support and teh traders.
• Provided an estimation of teh migration plan in terms of feasibility, time duration and resources.
• Extensively worked on SSIS packages and BCP to load large volumes of data into data warehouse.
• Capacity planning in estimating and sizing of tables.
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Used SQL Server Profiler to trace teh slow running queries and teh server activity.
• Involved in Login and User Management: Adding logins, roles, groups to teh Window NT and MS SQL Server and maintaining proper security procedures.
• Worked on database builds, cloning, performance tuning, load balancing, and backups/restores.
• Created OLAP Cubes and performing data mining on teh data using teh fact table and teh dimension.
• Involved in Server Database Installation, Administration, Backup & Restore Procedures, Database Security, SQL Database Development and Access database upgrading across teh enterprise.

Environment: SQL Server 2008/2008 R2, .Net, SSIS, SSRS, SSAS, Star Schema, VBA, T-SQL, ETL

Confidential

.Net Developer

Responsibilities:

• Involved in teh requirement gathering, document preparation, design, coding, testing and deployment of teh entire application.
• Developed Functions module to make teh system coding faster and efficient. Designed a large number of input screens.
• Developed web based reports like Monthly/Weekly/Daily Calendar for teh required departments and Session wif.
• Writing SQL Queries, Store procedures, User Defined Functions, Triggers in SQL SERVER 2005.
• Applying Data Transformation.
• Generating SQL Scripts and run into different machines to create new databases.
• Implementing Visual Source Safe for Configuration Management and Version control functionality. teh end users and managing and maintaining teh application.

Environment: C#, ASP.NET, SQL Server 2005, .NET Framework 3.5, IIS 6.0, HTML, VB Script, Java Script, Front Page, Windows XP

Confidential

.Net developer

Responsibilities:

• Developed a 3-Tier Web Application.
• Designed and styled teh Customer’s module web forms.
• Developed GUI by using Core Server Controls such as Dropdown List, Grid View, Menu and Side Map.
• Involved in Custom Validations implemented at mid-tier level to perform server-side validations.
• Designed and Developed an Interactive Graphical User Interface for various modules.
• Performed application-level Tracing, Debugging and Status Maintenance.
• Involved in Data communication between teh web application and databases.
• Wrote SQL Queries, Stored Procedures, and Database Triggers using SQL Server 2005.
• Involved in Tuning expensive SQL Queries for better performance.
• Consumed web services to enable communication between UI and different databases.

Environment: Microsoft .NET Framework 3.5, Microsoft Visual Studio 2008, C#, ASP.NET 3.0, ADO.NET, XML, HTML, CSS, JavaScript, IIS 6.0, SQL Server 2005