PROFESSIONAL SUMMARY:

• 5+ years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2014/2012/2008 R2/2008/2005 system in OLTP.
• Excellent experience in SSIS, SSRS of MS SQL Server.
• Highly expert in translating Business System Design document into technical design document.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• In - depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008R 2/ 2008/2005.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Strong knowledge of using variables and expressions in packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2012/2008R 2/2008/ 2005.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Expert in resolving the performance issue of SSIS packages.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
• Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Involved in Setting up Microsoft projects in TFS using Visual Studio 2010.
• Proficient in Creating business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Converting all operation excel report into Power BI Reports.
• Expert in creating and developing Power BI Dashboards in to rich look.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high pressure environment.

TECHNICAL SKILLS:

• SQL Server 2016/ 2014/2012/2008 R2/2008/2005
• SQL Server BI Development Studio (BIDS)
• MS Visual Studio 2008/2005
• SQL Server Integration Services (SSIS) 2012/2008R2/ 2008/2005
• SQL server Analysis services (SSAS) 2012/2008R2/2008/2005
• SQL server Reporting Services (SSRS) 2012/2008R2/2008/2005
• Power BI
• Oracle 10g/9i/8i
• MS Access
• T-SQL
• C
• C++
• C#
• HTML
• XML
• TFS
• Java
• ASP .NET
• VB6.NET
• Crystal reports
• Erwin7.2/4.5/4.0
• MS Visio 2007/2003
• ClearQuest
• Autosys
• DTS
• Windows7/Vista/NT/XP/ 2003/2000/98
• Rational Clear Case
• Windows 2000 Advanced Server

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer SQL/SSIS/SSAS/SSRS

Responsibilities:

• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Involved in enhancing and deploying the SSIS Packages from development server to production server.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS.
• Create low level design and ETL design doc according to requirement.
• Analyze existing ETL jobs and find the gaps.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Confidential, New York, NY

Business Intelligence Developer /SSRS/Power BI Developer

Responsibilities:

• Involved in requirement gathering meetings to understand requirements and future usage for the reports and documented them.
• Participated in data modeling meeting to help determine data modeling architecture and helped data modeling team to achieve best practices and performance.
• Worked on SQL Server development including writing T-SQL Quires and creating SQL Server objects like Stored Procedures, User- defined Functions, Views, Triggers, implementing T-SQL relational database models and data integrity.
• Used package configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Develop source to target data mapping documents and business rules for source to target transformations.
• Implemented user based security in SSRS reports to limit the access of reports.
• Responsible for scheduling the reports to run automatically.
• Developed reports using SSRS that could be used to send information to different clients, and managers.
• Design and monitor construction of user facing presentation tools, such as Microsoft SQL Server Reporting Services(SSRS) report and Power BI.
• Imported data from SQL Server Database, Azure SQL Database to Power BI to generate reports.
• Perform requirements Analysis, design and prototyping for Management Dashboards, Financial Reporting and operations Business Intelligence, using Microsoft Power BI, tool suite using Microsoft Stack experience in Azure SQL Server SSIS,SSAS,SSRS.
• Develop, publish Schedule reports and dashboards to meet business requirements.
• Build data models, visuals, reports, and dashboards using Microsoft Power BI.
• Ability to work on fast paced work environment.