PROFESSIONAL SUMMARY:

• Over 7 years of experience in Design, Development & Analysis of SQL Server 2005/2008/2012/2014 and SQL Server Business Intelligence Tools (BIDS) - SSIS, SSRS and SSAS.
• Experience with Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2005/2008/R 2/2012/2014.
• Development and Administration experience on Database Design and Implementation of OLTP and OLAP environment using SQL server 2005/2008/2012.
• Experience in Designing and Implementation of Relational Database Model for business requirements using Normalization forms.
• Good knowledge on SharePoint, Power BI and Cosmos.
• Experience in using MS system tools such as MS Sales, Commerce Platform and Commerce BI.
• Extensive experience in developing Stored Procedures, Functions (Arithmetic, String and Date Time) using T-SQL.
• Good understanding of RDBMS, Normalization /De-normalization and database modeling.
• Implemented Triggers at different levels of Database Objects to apply Security Constraints.
• Good at improving Performance using Table Indexes, Indexed Views by implementing Schema Bindings.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server IntegrationServices (SSIS 2005/2008/R2/2012), DTS, Bulk Insert and Bulk Copy Program utility.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Worked with Flat file, Excel file, and SQL server OLEDB destinations for loading data.
• Generated VB and C# scripts used for Script task. Script task is primarily to control the flow of SSIS package.
• Experience in generating Ad-Hoc, Drill Down, Drill through Reports using Local and Global Variables, Expressions and Filters in SSRS.
• Experience in working with front end tools and Agile methodologies.
• Expert in creating Parameterized Reports, Matrix Reports, and Custom generated reports, Charts, Sub Reports as per Business User requirements.
• Experience in CRM Tools like Sales Force.
• Experience in Teradata and Hands-on experience with Informatica.
• Experience in using Table variables and CTE (Common Table Variables) and also familiar with Agile environment.
• Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRSand experience in SAP application.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule DTS/SSIS Packages.
• Expert in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Experience in working with Informatica tools.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Pie Chart Reports, Drill-down, Top N, Summary and Sub reports, ad-hoc reports and formatting them.
• Hands-on experience with Tableau reporting tool and experiences in classic ASP.
• Experienced in writing VB scripts for user defined functions and report manager scheduling in SSRS.
• Good knowledge using .Net Code and C# code in SSIS Packages, Configuration and Release Management Process.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated the metrics that were revealed in the functional analysis.
• Good knowledge of Defining, Developing and Deploying and building out a DataMart using Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server 2005 Analysis Services (SSAS) on EDW.
• Knowledge in Identifying Facts and Dimensions for Cubes with MDX queries in SSAS 2005/2008/R2/2012.
• Handful knowledge on creating Mapping documents for SSIS Packages and Implementation Projects.
• A multi-tasking Analytical Thinker with the ability to work on fast paced work Environment.
• Strong communication skills and an ability to work individually or part of a team and good learner to adapt new technologies that improve the business.

TECHNICAL SKILLS:

Relational Databases: SQL Server 2012/2008/R2/2005/2000, Oracle 10g/9i/8.0, MS Access, MS Excel, DB2, Sybase.

Tools: and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, Erwin, DTS, Microsoft Visual Source Safe, Crystal Reports9.0, MDX, Visual Studio .Net, Octopus, Visual Source Team Foundation Server (TFS), JIRA

Languages: T-SQL, PL/SQL, V.B6.0, C, C#, ASP.Net, VB.Net.

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS.

Database Design Tools: MS Visio, Erwin.

Web Technologies: HTML, XML, XSL, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007.

PROFESSIONAL EXPERIENCE:

Confidential, Trinity, NC

SSIS Developer

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into Microsoft Dynamics AX.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Data Stage and Text format data) to SQL Server
• Written complex SQL queries, Stored Procedures, Triggers, Views, DML, DDL and user defined functions to implement business logic and also created clustered and non-clustered indexes.
• Experienced in writing complex SQL queries, Stored Procedures, Triggers, Views, DML, DDL and user defined functions to implement business logic and also created clustered and non-clustered indexes.
• Written SQL Queries to get the data back to SQL Server from AX.
• Written Stored Procedures, SQL Queries and Designed SSIS package for Auditing the data in different environments.
• Developed SSRS reports for comparing the data in different environments.
• Developed an application in Visual Studio which is also used by the end users for getting the auditing results.

Environment: SQL Server 2014/2016, Microsoft Visual Studio 2015, SQL Server Management Studio, SQL BI Suite (SSIS, SSRS), T-SQL, TFS,Agile, C#

Confidential, Cary, NC

SQL Developer/ Analyst

Responsibilities:

• Designed and implemented Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager.
• Generated SSRS reports which included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through, sub-reports, navigation reports.
• Created Parameterized Reports like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal and default like queried and non-queried.
• Created Linked reports, Ad-hoc reports based on the requirement. Linked reports are created in the Report Server to reduce the repetition in the reports.
• Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Created Stored Procedures to validate the data coming with different data discrepancies using data conversions.
• Created sub reports, bar chart, matrix reports, Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports for newly created Markets.
• Wrote stored procedures for report generation in SQL Server2012.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Design and development of Micro Strategy schema objects like Attributes, Facts and Hierarchies using Micro Strategy Architect
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Created Logical views in Micro Strategy for complex report creation scenarios.
• Used free form SQL editor for complex report creation.
• Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.
• Implemented Complex Stored Procedures for Providers and Members for various clients.
• Experienced in writing complex SQL queries, Stored Procedures, Triggers, Views, DML, DDL and user defined functions to implement business logic and also created clustered and non-clustered indexes.
• Encapsulated frequently used SQL statements into stores procedures there by reducing the execution time.
• Imported flat files using SSIS packages, BCP command and PDI tool.
• Developed various SSIS packages based upon the source files using various control flow and data flow tasks.
• Deployed SSIS packages involving complex Transformations like Slowly Changing Dimension, Fuzzy Grouping, Merge, Merge join, Pivot, Un-pivot.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Preparing Dashboards using calculations, parameters in Tableau.

Environment: MS-Access, SQL Server 2008/R2/2012, Visual Studio, SQL BI Suite (SSIS, SSRS, SSAS), T-SQL, TFS-2008, Windows Server 2003, IBM-AS400, Oracle 11g, Agile, C#, Microsoft Visual Studio, Micro-Strategy.

Confidential, Bluffton, SC

SSIS/ SSRS/ SSAS Developer

Responsibilities:

• Worked with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs.
• Querying, creating stored procedures and writing complex queries and T-SQL Joins to address various reporting operations and also random data requests.
• Point of contact for all the Data processes, Data Mappings, Data dictionaries, Data pulls and Reporting solutions.
• Designed and Developed SSIS Packages to import and export data from MS Excel, XML, SQL Server 2008,Flat files, DB2 and used SSIS Package Configuration, Expressions, passing variables dynamically, logging, Event Handler.
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, schedulingtasks, embedding views in the Tableau Server.
• Designed complex T-SQL queries, User Defined Functions; Stored Procedures and Triggers followed by thorough analysis and testing of those database objects before deployment to the production server.
• Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
• Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
• Scheduling the report on the SharePoint for the delivery to the end users.
• Integrated SQL Server 2005 reporting services (SSRS) with Microsoft Office Share point Server to automatically deliver reports to the Share Point portal.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point.
• Created Drill-through reports, parameterized reports and linked reports using SSRS and were integrated in the Performance point server.
• Used Cosmos scripting in writing queries.
• Created SSIS packages and used Analysis Services (SSAS) processing task to update the cube with current data.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Used Shell scripting andTera-Data.
• Experienced in working on big data using SQL.
• Used agile technologies.
• Used MDX queries to crate OLAP cubes in SSAS.
• Creating and maintaining various subscriptions in the Report Manager for the reports.
• Experience in testing EDI docs with new mappings and existing production issues.
• Developing products by determining what competitors are doing, risk assessments, ratings assessments, pricing and coverage.

Environment: SQL Server 2008R2/2008/2005, SQL BI Suite (SSAS, SSIS, SSRS), T-SQL, Visual Studio, Team Foundation Server, C#, Visual Source Safe (VSS), Oracle, Pl/SQL, Share Point, MS Project, MS Access 2003/2007.

Confidential, Chantilly, VA

SQL BI Developer

Responsibilities:

• Interacted with Business team to collect data for the conceptual design of the system.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Migrated crystal reports to SQL Server Reporting Services (SSRS).
• Assisted internal and external reportneedsand designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Created and developed the stored procedures, triggers, views and user-defined functions to support application development using T-SQL.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed and configured the reports in the Report Server.
• Worked closely with IT project managers, programmers, and testers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimized Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Responsible for Documenting the requirements, design and coding changes. Maintained versions for the code for every change. Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production.
• Trained end users with step-by-step instructions to access the pre-build or published reports.
• Designed and developed various complex reports and different types of charts.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Created drill down, drill through, sub reports, chartsand many more complex reports depending upon the Business Requirements.
• Created interactive data exploration, visualization and presentation using power view.
• Used power pivot to import data from sources such as SQL Server, XML, Microsoft Access and even web based data.

ENVIRONMENT: Windows XP, MS SQL Server 2008R2, SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential

SSRS, SSIS, SSRS and PL SQL Developer

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Generated database monitering and data validation reports in Proclarity and SQL Server Reporting Service (SSRS ).
• Created Datawarehourse Cubes in SQL Server Analysis Service (SSAS) .
• Deployed SSIS packages and Reports to Production Servers.
• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Responsible for the design and development of .Net web applications for firm's Solutions.
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provide high availability support.
• Created partition table for very large database for good performance.
• Worked on Migration of packages from DTS using SQL Server Reporting Service(SSIS).
• Participated Databases Architecture and data Modeling design.
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Fully supported change management procedures.
• Reviewed and developed data models and database designs with development teams
• Wrote store procedures for some job automations.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Designed and developed OLAP using MS SQL Server Analysis Services
• Designed and developed MS SQL ServerReporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
• In charge of converting data using SQL Server 2005 using SSIS

Environment: MS SQL Server 2005 and 2000, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS, Power builder 12.5, Proclarity, MS SQL Server Analysis Services 2000, C#, ASP.NET,VB.NET, OLAP, UML, Erwin, DTS/SSIS,BIDS, PL SQL, Oracle.