PROFESSIONAL SUMMARY:

• Over 8 years' experience as a MS SQL Server Developer in TSQL/SSIS and SSRS Development in Finance, Retail and Communication Domains
• Experienced in installation, configuration and maintenance of MS SQL server 2012/2008R2/2008/2005, SQL Profiler, Execution Plan and Performance Monitor
• Engage with project teams as a technical / development lead to deliver enhancements and new business capabilities.
• Define detailed technical design specifications to meet functional objectives.
• Define data and interface requirements.
• Execute MDM systems development, configuration and unit testing.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Expert in using BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2005 and 2008R2.
• Extensive knowledge in developing and implementing disaster recovery model, log shipping and replication models coordinate with SQL DBA in Backup and Recovery of MS SQL 2000/2005/2008 R2/2012 Server Database.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.
• Ability to work excellently as an individual and also as a proactive team member with minimum amount of supervision.
• An excellent Inter-personal skill with ability to develop creative solutions for challenging client needs using design pattern.

SKILLS SET:

Database admin ,Web development with extensive experience designing, coding, testing and supporting next-generation database and application Proficient in SQL Server 2008R2/2005/2000, SSIS, SSAS, SSRS, Asp.net MVC 1.0/2.0/3.0, C, C , HTML, Xml, Css, jQuery, JavaScript, AJAX, LINQ.

PROJECTS SUMMARY:

Confidential

MS SQL BI Developer / Microstrategy Reporting

Responsibilities:

• Involved in creating multi-tiered and multithreaded applications using .Net framework.
• Analyzed the user requirements and defined technical specifications. Involved in all activities of Software Development Life Cycle SDLC
• Designed the migration strategy, test plan and scripts to verify data and migrated databases from SQL server 2008 to SQL Server 2012.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance.
• Worked on data cleansing using visual studio 2010 or SSIS 2012.
• Used multiple transformations including Fuzzy lookups and Fuzzy grouping in the data cleansing process.
• Combine MDM technology expertise with data and statistical analysis to optimize MDM software identify options, analyze, recommend, present and execute .
• Collaborate with other engineers and enterprise architects to define solution architectures applications, data, and technology .
• Provide support and guidance to the MDM quality assurance, support and offshore engineering team.
• Designed and developed the Presentation layer and Data Access layer. Implemented column level encryption AES Encryption on the Loan-Look application.
• Import data from As-400 using SSIS. Used various transformations like Merge, merge Join, Lookup, Conditional Split, Derived Column, aggregate transformations to validate and cleanse the data that was coming from As-400.
• Configured and deployed the packages into the testing and production server. Scheduled a job thru' SQL Server Agent to run automatically.
• Implement business rules on each page such as Overview, My budget, lender Contact etc. .
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks.
• Assisted in planning the complete backing up of database. Performed disaster recovery and database maintenance plan and involved in replication of Data Transactional method used .
• Extensive experience on Enterprise Reporting, Ad hoc query ROLAP analysis.
• Extensively worked in creating and integrating MicroStrategy reports and objects Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups with the data warehouse
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Used Team Foundation Server TFS for version control, source control and reporting.
• Very strong in developing Proactive Delivery Reports and implementing business intelligence solutions on the web using MicroStrategy Narrowcast Server.
• Expert in Creating MicroStrategy Reports and implementing MicroStrategy projects.
• Extensive work experience with Ad hoc reporting and standard reporting environment

Environment:

ASP.NET MVC, C .Net, .NET Framework 3.0/3.5, SQL Server 2008/2008R2/2012 , SSRS, Windows JavaScript, LINQ, EF, Microstrategy 9.3.

Confidential

MS SQL / BI DEVELOPER

Hardware/Software: MS SQL Server 2008, T-SQL, MS SQL Server Integration Services 2008, MS SQL Server Reporting Services 2008, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2008/2010, Erwin Data Modeler, Windows XP, MS Office 2003/2007/2010, MS Access.

Responsibilities:

• As a team member interact with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.
• Incorporated the DTS Packages into MS SQL Server 2008 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the slowly Changing Transformation to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Views to reduce database complexities for the end users.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Provided report generation solution to the clients using different versions of Crystal Reports best suited for the business requirements.
• Involved in Report writing according to business requirement using SSRS and Crystal Reports.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Data Analysis and Designed the logical and physical model architecture for database.
• Created DDL Scripts using Forward Engineering in Erwin to create tables in Database and also used Reverse Engineering to create Data Models with already existing tables.
• Worked on Intelligence Server Clustering.
• Configured Enterprise Manger and worked on reports.
• Involved in monitor the statistics about objects, reports and user sessions by using Enterprise Manager.
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
• Did Web customization, added Web custom log and Web custom text on login page
• WAR files deployment on Web Application Server.
• Upgraded Micro strategy v 9.0.2 to Micro strategy v 9.2.1
• Created Services using Subscription sets, Schedules

Confidential

MS SQL Server Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server 2005 on the production server.
• Automated the migration of data from Oracle DB to MS SQL Server 2005 DB using Microsoft SQL Server Migration Assistant SSMA .
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Converted the Oracle DB objects to MS SQL Server 2005 DB objects like tables, views, and stored procedures.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2005 and also validated the migration process to ensure that it has been successfully migrated.
• Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• 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.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Defined referential relationships with the measure groups and fact tables.
• Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.
• Defined granularity within a measure group and drill through actions.
• Created cube reports that can be browsed at summary level and can be drilled down to the detail level.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Documented the development work and production release for future reference.
• Involved in Dimensional Data Modeling Star Schema, Snow-Flake Schema Data Architecture, Business and Data Analysis
• Responsible for keeping team members on track toward completing the terms of goals
• Involved in installation and configuration of MicroStrategy 8.1.1
• Creating Schema Objects facts, attributes, hierarchies, Transformations and application objects filters, prompts, metrics, reports needed to create the MicroStrategy objects necessary for the deliverable
• Architected the projects and created all the necessary schema, application and configuration objects
• Creating advanced metrics level, conditional , filters, consolidations, custom groups and reports with VLDB properties

Environment:

SQL Server 2005, Management Studio, SQL Server Integration Services SSIS , SQL Profiler, Database Engine Tuning Advisor, JavaScript, HTML, XML, Erwin.

Confidential

SQL Server/BI Developer

Responsibilities:

• Database upgrade from SQL server 2000 to SQL Server 2005.
• Perform Back-ups, Restores, Scheduling, Maintenance
• Created SSIS packages to ETL data into production system and to produce/schedule management control reports.
• Extensively worked on converting DTS packages to SSIS packages.
• Developed SSIS packages to load data from application database and flat files into destination database.
• Used Derived Column transformation to perform various calculations.
• Implemented package configurations in SSIS packages that allow transferring packages from one environment to other.
• Deployed SSIS packages to production, schedule them to run on routine basis and monitor the error log for any errors.

Environment: SSIS, MS SQL Server 2005, DTS, SQL Server 2000, Windows, C-Sharp, Erwin Data Modeler