SUMMARY

• A skilled software professional with over 7+ years of IT experience in Development, Design, Analysis and Testing client server application using Microsoft SQL Server and BI suite.
• Excellent knowledge in RDBMS and Microsoft SQL Server 2005/2008/2008 R2/2012.
• Experience in Installation, Up - gradations, Configuring and Maintenance of Microsoft SQL Server 2008/2008R2/2012 and Microsoft visual Studio 2008/2008R2.
• Experience in developing the applications using T-SQL Programming (DDL, DML and DCL).
• Hands-on experience in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL Server Analysis Services (SSAS) using Business Intelligence Development Studio (BIDS).
• Expert in creating complex mappings using various transformations and developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica.
• Worked on Notification services, setting up jobs and alerts through SQL Server Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database.
• Worked on upgrading from DTS to SSIS packages.
• Experience in creating MDX queries to access cubes in SSAS.
• Experience in Data warehouse, Star Schema Modelling, Snow-Flake Modelling, Fact & Dimension tables, Physical and Logical Data Modelling.
• Experience in designing Database Models using Microsoft Visio and creating class diagrams, activity diagrams, use cases diagrams, sequence diagrams and flow charts using UML.
• Experience in creating snapshots of reports as well as worked on integration of SharePoint with SSRS.
• Designed, developed and deployed many SSRS Reports on SQL Server Reporting Services.
• Experience in Design, Development, Implementation and Documentation of business requirements in Microsoft ADO.NET, C#, VB.Net, Web Applications, Windows Applications and XML.
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Detail-oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills.
• Extremely motivated, diligent, conceptually strong team player with ability to take new roles and adapt quickly to new technology.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2005/2008/2008 R2/2012,Oracle 9i/10g, MS Access 2003/2007/2010/2013

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Business Intelligence Studio, RedGate, CITRIX

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Informatica

Reporting Tools: SQL Server Reporting Services (SSRS), MS Access 2003/2007/2010/2013 , Crystal Reports 9.0/10

Data Modeling: MS Visio

Operating Systems: MS Windows 98/2000/XP/Vista/7/8/8.1/ UNIX, Shell scripting

Languages: T-SQL, PL/SQL, C, C++, HTML, XML

PROFESSIONAL EXPERIENCE

BI Developer

Confidential, Richmond, VA

Responsibilities:

• Work with the attorneys and analysts to identify unique requirement of each project and then design, update, and report from custom-built platforms.
• Install and Configure MS SQL SERVER 2008R2/2012 on Windows XP Professionals and Windows 7.
• Major work is associated with generating reports for multiple client projects like Deepwater Horizon (BP) and Chinese Drywall as well as company’s internal BG project.
• Created several SSIS packages in Business Intelligence Development studio (BIDS) to extract data from Excel sheets as well as from OLTP systems and loaded into staging databases.
• Transferred data between Data Mart and Data Warehouse using Bill Inmon as well as Ralph Kimball methodologies in SSAS.
• Use Analysis Services Multidimensional and Data Mining Project for creating cubes.
• Write MDX queries for front end applications as well as create KPI Objects as per the requirement.
• Create reports by extracting data from cubes.
• Create different types of reports including Cross-tab, Tabular, Charts, Graphs, Sub reports, Drill-down reports with Cascading Parameter prompts.
• Generate various kinds of reports using Graphs and Images, KPI indicators.
• Deploy SSRS reports using Report Manager and schedule the reports to generate daily, weekly, monthly and quarterly reports including current status.
• Develop, analyze and execute queries using SQL server to provide Ad Hoc report through Citrix and RedGate.
• Compare and synchronize data using RedGate SQL Tool.
• Write and execute complex stored procedures in T-SQL that involved complex multi-table relationships using SSMS to summarize the data in staging environment.
• Write recursive queries using Common Table Expression (CTE).
• Design Claim forms using SSRS and Crystal Reports for the Claimants to file claims which is then exported to PDF format.
• Generate Dynamic as well as Static Reports with claimant information which is sent to reviewers, lawyers as well as to the court.
• Create triggers on master data tables in OLTP to keep track of insertion and updates.
• Create several User-Defined Functions to server miscellaneous purposes like getting a comma-separated list of values, performing aggregation etc.
• Identify, test, and resolve database performance issues (monitoring and tuning) to ensure database optimization.
• Perform SQL Server installation in Share-Point Integrated mode.
• Deploy SSRS reports on Report Server using Report Manager, as well on SharePoint Server.
• Schedule jobs to generate daily, weekly, monthly and quarterly reports including current status.
• Use VB.Net as well as C# in script task and script components and made use of ADO.NET classes to manipulate data.
• Create reports using Expense Management System.
• Work as a primary programmer as well as a secondary programmer for many reports.
• Communicate through ooVoo with remote programmers in the team and work with them to generate reports as well as verify their codes as a secondary programmer.
• Create RDLs for the remote programmer’s reports after the approval given by the Project Manager which then gets moved to the portal.
• Review existing reports on the portal and spot discrepancies in the data with the help of the Business Rules.
• Work with the Project Manager and Team lead to provide them with inputs during meetings regarding modifications in Business Rules.

SSIS/SSAS/SQL Developer

Confidential, Des Moines, IA

Responsibilities:

• Actively participated in teams to gather requirements to developBI Projectand also participated in Designing Physical and Logical design ofData warehouse.
• Participated in design ofStaging DatabasesandData Warehouse databaseusingStar Schemawhich includes Table Store Procedure and Indexes in SQL Server Management Studio (SSMS).
• Involved inperformance tuningofSQL queriesand stored procedures usingSQL ProfilerandIndex Tuning Wizard.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager, if the entire field were not entered by the data entry person regarding screening usingSQL Server Agent.
• Used ETL to obtain temporary subset ofdata for somereports.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• CreatedProfiling, Cleansing and Auditingplans withSSISPackages.
• Implemented Logic withlookup tableto maintainParent-Child relationshipand maintainhierarchy.
• Used transformation likeMerge Join, Pivot, lookup, Fuzzy lookup and Slowly Changing Dimension.
• UsedPackage Configurationto migrate SSIS package from one environment to other.
• Used differentcontrol flow controlslikefor each loop container, Sequence container, Execute SQL task and Send mail task.
• UsedEvent handling to send E-mail on eventlike on error.
• Created differentUser level groups, and assigned appropriatepermissionlevel to the database using Credentials tool.
• UsedData Viewersin SSIS Packages to check the flow of data during Execution of Packages.
• Wrote stored procedures to summarize the data in staging environment and then developed SSIS packages to load the summarized data in Data warehouse, Data Mart Dimension and Fact Tables.
• Created bunch of Cubes in SSAS using BIDS and deployed them successfully on Analysis Services Databases, and created various ad-hoc reports and exported them into MS Excel.
• AppliedConfiguration, Logging, Error reportingto all packages to make package deployment easy and troubleshoot package on run time.
• Loaded data in Data Warehouse by usingSlowly Changing Dimension (SCD - Type 1, 2, 3).
• Use VB.Net as well as C# in script task and script components and made use of ADO.NET classes to manipulate data.
• Develop some in-house applications using C# and VB.NET using Visual Studio 2008 which were lying on SQL Server databases.
• Worked on Informatica 8 using necessary transformations.
• Involved in the performance tuning of Informatica mappings/sessions for large data files by increasing block size, data cache size, and commit interval.

BI Developer

Confidential, Portland, ME

Responsibilities:

• Gathered Requirements from the end user and checking the structure of the schema and data with the Data Modular.
• Imported Metadata and created Presentation Layer, Business Layer, Data Source Layer and Physical Layer.
• Created Metadata Models and published package to improve the overall end user experience.
• Troubleshot report failures, Web page failures, document findings, and implement solutions.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Processed cube to perform incremental updates.
• Made use of KPI, MDX queries, Perspectives and Translations in SSAS to create indicators and translate according to the requirements.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Created a directory path in integration and Production.
• Defined aggregations required and granularity available and required in DW.
• Created and maintained databases after logical and physical database design in SQL Server 2005/2008.
• Migrate Database from SQL Server 2005 to SQL Server 2008
• Set database access privileges for different users and user groups in SQL Server 2008.
• Developed backup & restore scripts for SQL Server as needed.
• Tuning and optimizing queries and indexes.
• Managed MDX Cubes and partitioning of cubes.
• Wrote complex queries using Oracle 9i.
• Looked at the reports and fixed bugs in stored procedures.
• Implemented different types of constraints on tables.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Worked with users in training and support.

SQL Server/SSAS Developer

Confidential

Responsibilities:

• Involved in the entire System study, analysis and design.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Involved in the analysis of how the purchase order process was organized.
• Created SQL tables with referential integrity and developed queries using SQL.
• Involved in writing Triggers which internally called procedures and functions.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Built Multidimensional cubes using SSAS.
• Created reports by dragging data from cube and wrote mdx scripts.
• Reviewed Cube with end user and changing the cube and documentation according to their requirements.
• Optimized cubes for better query performance.
• Supported technical teams involved with MS SQL issues and operations.
• Involved in the maintenance of the database.