PROFESSIONAL SUMMARY

• 8+ years’ experience in Requirement Gathering, Analysis, Design, Software Development, Testing, Tableau and Business Intelligence (SSIS, SSRS, SSAS).
• Excellent experience in Designing, Maintaining & Tuning various RDBMS like T - SQL & MS SQL Server 2005/2008/2008 R2/2012/2014, MS Access databases and strong knowledge of SDLC principles.
• Expertise in creating Sub-Queries and Joins for complex queries involving multiple tables, error handling and Exception Handlers used in Stored Procedures, Views and User Defined Functions.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Involved in Query Optimization and Performance Tuning using SQL Profiler, Index Tuning Wizard and Stored Procedure Debugger.
• Proficient in SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits, Aggregate, Derived Column, Event Handlers, and Error Handlers etc. and extensively used SSIS to load Data Warehouses.
• Strong experiences to design, deploy, and maintain various SSRS reports in SQL Server.
• Excellent experience in designing and developing stylish and complex reports like reports using Drill Down, Sub Reports, Cascading parameters, Drill-Through Reports, Parameterized Reports, Chart Reports and ad-hoc reports using Global variables, Expressions and Functions for Business Users using SQL Server Reporting Services (SSRS).
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server Analysis Services Business Intelligence (SSAS, SSRS).
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using Multidimensional Expression (MDX).
• Involved in coding new and maintaining current business applications and systems using SQL.
• Experience in developing testing and debugging.
• Excellent interpersonal skills with problem solving and analytical skills.
• Strong communication skills (oral and written) along with good organizational skills.

TECHNICAL SKILLS:

• MS SQL Server 2014/2012/2008 R2/2008/2005
• MS SQL Server Integration Service (SSIS)
• MS SQL Analysis Services (SSAS)
• MS SQL Reporting Services (SSRS)
• MS SQL Profiler
• SQL Query Analyzer
• Database engine tuning advisor
• Power Designer
• Erwin Data Modeler
• Lucid Chart
• MS Access
• MS Excel
• MS Outlook
• MS Visio
• MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

MSBI Developer

Responsibilities:

• Coordinate with offshore development team, assign them tasks and help with any technical queries.
• Enable dynamic logging of package run into a text file.
• Enable error handling strategy i.e. transaction isolation to help rollback of transaction when package fails.
• Enable auditing of package and underlying expensive tasks into a database table, to help in performance tuning.
• Created SSIS packages to load data into RHI SQL server from WellPoint’s data warehouse.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Use TFS (Team foundation server) source control tool to check in all of the codes in daily basis.
• Use waterfall SDLC process.

Environment : SQL Server 2005/2008R2/2012 Enterprise Edition, .Net 3.5,SQL SQL Server Data tools (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects.

Confidential, Washington, DC

SQL/ETL/SSIS Developer

Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Extracted data from XML to SQL server.

Environment : SQL Server 2005/2008R2/2012 Enterprise Edition, .Net 3.5,SQL SQL Server Data tools (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007

Confidential, Dallas, TX

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Created and managed stored procedures, indexed views, user-defined functions, triggers, and database constraints to meet business requirements and policies.
• Created complex queries for database auditing purposes.
• Used DTS/SSIS for ETL processes, SSRS for reporting needs, and SSAS for analytics reporting including SharePoint integration.
• Created highly complex SSIS packages using various data transformations like conditional splitting, fuzzy lookup, multi-cast, column conversion, fuzzy grouping, script components, and error handling.
• Generated custom ETL scripts using SSIS 2005 and unit tested load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Gained understanding of OLAP processing for changing and maintaining warehousing optimizing dimensions and hierarchies and adding aggregations to cube.
• Involved in writing MDX queries and performance optimization of SSAS cubes for calculated members and measure groups.
• Created various complex reports and managed them using SSRS 2008/2005 according to ERLC.
• Involved in migration and conversion of reports from SSRS 2005 to 2008.
• Created tabular reports, matrix reports, list and chart reports, parameterized reports, sub reports, ad hoc reports, drill-down reports and interactive reports according to business requirements in time-restricted environment.
• Created SSRS report model projects in BI studio and created, modified, and managed various report models with multiple model objects, source fields, and expressions.
• Highly involved in creating, structuring, and formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate special reports according to client needs.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007 and SharePoint.
• Deployed designed PPS dashboards and reports in MOSS site using PPS Dashboard Viewer Web Part for web-based access for multiple end users.

Environment: SQL Server 2005/2008/2008 R2 Enterprise Edition, .NET 3.5, SQL BI Suite 2008 (SSAS, SSIS, SSRS), Enterprise Manager, PPS, XML, PowerPoint, Project, Access 2003,Windows Server 2003, Oracle, Crystal Reports, Cognos, Business Objects, SharePoint, MOSS 2007.

Confidential, Albany, NY

SQL Developer .

Responsibilities:

• Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Developed Aggregations, Partitions and Calculated Members for cube as per business requirements.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created Parameterized reports, Drill down and Drill through reports using SSRS.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: SQL Server 2008R2/2008, BIDS 2005, SQL Server Reporting services 2008, Integration Services 2005, Analysis Services 2005, Oracle9i, DB2.

Confidential, New York, NY

Junior SQL Developer

Responsibilities:

• Assisted with the development of logical database designs, data models and relational database definitions.
• Wrote SQL queries to populate data from different tables, which could be used for reports.
• Created SSIS packages including a variety of transformations, for example, Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Created drill down reports by linking data from Data Warehouse Cubes using SSRS 2005.
• Deployed the generated reports on the server.
• Monitored the table-spaces for the production databases on daily basis and increasing the sizes if required.

Environment : SQL Server 2008/2005/2000 , Microsoft Visual Studio 2005, SSIS, Data Transformation Services (DTS), SSRS 2005, Report Manager, Report Viewer, Oracle 9i, Excel, Outlook 2003, Microsoft Visual Source Safe(VSS) 2005.

Confidential, Cynwyd, PA

Junior SQL Developer

Responsibilities:

• Worked closely with BA, DBA to analyze business model, gather project requirement, and translated user requirements into conceptual, logical and physical data models.
• Developed, modified, and optimized complex queries to data retrieval and modification.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Migrated SQL server 2005 to SQL Server 2008 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
• Extracted data from Oracle DB using Import Export Wizard in SQL Server Management Studio.
• Used tools such as SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Documented the procedures and process.

Environment: SQL Server 2008/2005/2000 , Windows Server 2003 R2 Enterprise.