PROFESSIONAL SUMMARY:

• 5+ years of experience as Business intelligent in Production, Development, and staging Environment.
• Hands of experience in installing, configuring, managing, upgrading and migrating, monitoring, and troubleshooting SQL Server 2000/2005/2008 R 2/2012/2014.
• Involved in Huge data Migrations, transfer using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP), and Bulk Insert.
• Involved in MSBI projects with extensive usage of ETL and Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Experience in Cube Analysis using MS - Excel with Excel Power Pivot.
• Experience in various types of tasks control flow and data flow in SSIS.
• Deep knowledge of Data Warehousing methodologies and concepts, Including Star Schemas, Snowflakes, ETL processes, Dimension modeling and reporting tools.
• Experience in working with SQL Server Analysis Services (SSAS) in Creating data source views, Named queries, Calculated Columns, Cubes, Dimensions, Roles and Deploying of Analysis Services projects.
• Developing tools using Access, VBA, and Excel environment.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Expert in Data Modeling and Multi-Dimensional Modeling.
• Involved in writing, modifying new/existing TSQL and MDX Queries as part of bug fixing in the existing ETL/Reports or to build any ad-hoc reports.
• Strong Experience in Creating Different Reports like Drill through Dashboard Reports, Drill down Reports, Cascading, Matrix Reports, Sub Reports, AD hoc Reports, Tabular Reports and Charts Reports.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database objects like tables, Constraints and Indexes using DDL, DML, DCL Commands.
• Creating MDX queries with calculations, KPIs, Actions, Partitions and Aggregations in SSAS.
• Highly qualified in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE, Table Variables and strong knowledge of SDLC principles.
• Involved in all-phases of software development life cycle: Design, Implementation and Unit Testing.
• Have reviewed various stored procedures with options, Function and TSQL code and Improved the performance of queries by suggesting the DBA for appropriate Index, Views and join Hints.
• Experience in programming tasks-stored procedures, triggers, cursors using SQL Server 2012/2014 with TSQL.
• Extensive experience in Deploying and consolidating multiple instances over Clustering Environment and Remote Installations.
• Configure the ETL packages, Cubes in jobs and scheduling the Jobs using SQL Server 2012.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS:

Database Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), SSRS

Reporting Tools: SQL Server Reporting Services ( 2000/2005/2008 R2,2012,2014), MS Access, MS Excel, Tableau

DATABASE: SQL, MySQL, Oracle, Mongo db, MS SQL Server 2014/2012/2008/2005/2000, MS Access, Oracle 9i/8i/11g

Version Control: RTC, Git Hub, Subversion, CVS, SVN, Bit Bucket

Operating system: Windows XP, 7, Mac OS, Unix, Windows (95/98/2000), Windows 2003/2008 Server, Windows Vista

Programming: C#, Java, J2EE, Web services(SOAP, Restful), C, C++, PHP,T-SQL, PL-SQL, C

IDE: Sublime, Eclipse, Notepad++

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

SQL Server TSQL/SSIS/SSRS/MSBI developer

Responsibilities:

• Participated in daily agile scrum meetings to understand business logic and requirements of the company and provide optimal solutions to the users.
• Worked with Business architect to determine logic for the new data warehouse, and for integration process.
• Created model for data warehouse created and wrote DDL scripts for different database objects as tables, stored procedures, triggers and user defined functions.
• Designed SSIS packages for transient and persistent staging area, to extract data from SAP and different applications, from excel files and flat files using for each loop container, sequence container, and tasks such as execute SQL task, look up, merge, merge join, un pivot etc.
• Wrote complex TSQL queries to get data from different sources and test results with expected results.
• Custom SSRS 2012 reports as well as some Tableau reports for large customers and senior executive leadership.
• Gather and translate business requirements into report designs.
• Design and monitor construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports.
• Design and monitor the construction of an enterprise data warehouse.
• Implemented performance tuning for slow running packages, using execution plan and SQL Server Profiler. Implemented parallelism in SSIS.
• Generated and optimized already existing views to enhance performance for creating reports and SSAS cubes.
• Used different data transformations such as Derived column, Conditional split, Multicast, slowly changed dimension etc.
• Designed and implemented logic for loading data to the dimension and fact tables.
• Implemented special logic for late arriving dimension records.
• Created parameter tables and inserted parameters for each package which is used to retrieve information about package on run time enabling packages work dynamically.
• Utilized SQL Server table configurations and environment variables to dynamically run packages.
• Executed event handler and error handler mechanisms in SSIS and wrote C# code to retrieve customized information about error if package fails and insert useful information to the audit log tables.
• Worked with SQL Server Job Agent to schedule packages, run and monitor them.
• Used Team Foundation Server to keep track of new created SSIS packages, and to modify and update existing packages when it is necessary.

Environment: MS SQL Server 2012, T-SQL, SQL server Integration service 2012, SQL Server Reporting Service 2012, Erwin7.3, SQL Profiler, C#, SSAS.

Confidential, NY

SQL Server Developer/SSRS/SSIS

Responsibilities:

• Developed database objects such as SSIS Packages, Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving. Multiple tables & calculations from different databases.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Monitored the SQL profiler and tuned queries and procedures to boost database performance.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, Data Mart databases.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Used various SSIS tasks such as Conditional Split, Script Component Task, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data Warehouse.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Used Bulking techniques, Table partitioning to increase database performance.
• Consistently worked and communicated with CMS (Center for Medicare & Medicaid) to ensure data received met the company expectations.
• Wrote complex expressions and calculations for SSRS reports with Conditional Formatting.
• Responsible for the design and deployment of the report using SSRS and MS Excel.
• Created Ad Hoc reports by building models in Report Builder using SQL 2008 Model Designer and Report Builder.

Environment: SQL Server 2008, Oracle 10g, T-SQL, BIDS, SSRS, SSIS, SSAS, Crystal Reports, Power BI, MS Excel, Erwin, SharePoint.

Confidential, Lexington, KY

Data Analyst

Responsibilities:

• Creating and managing tableau reports using advanced chart types, filters and complex calculations.
• Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Analyzed the total cash flows and share values of the firm using line charts to analyze the patterns and trends.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in end to end development of the report by gathering requirements, provide business solutions, deploying and maintaining tableau reports.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Coordinated with senior management and integration teams to ensure quality deliverables.
• Ensured projects were completed on time with high quality and expected estimates.
• Played key role in enhancing client's Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Sophisticated stored procedures and triggers to provide complete technical solutions.

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Hive, HDFS, Flume, Sqooq, R connector, Python, R, Tableau 9.2.

Confidential

MSBI Developer

Responsibilities:

• Involved in gathering, understanding and validating the project specifications.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services-2008.
• Good Knowledge and working exposure in Informatica Power Center 9.5
• Developed complex T-SQL queries for the ETL packages.
• Designed packages in SSIS 2008 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task. .
• Built Synchronous and Asynchronous scripting component for different modes of output.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Created packages with Ragged Right data mapping.
• Closely working with category for implementation master data management (MDM) of new products, customers and vendors.
• Migrating from Informatica 7.1.4 mappings into Informatica 8.5.1 which consists of grid technology.
• Understanding the domain and nodes as well as by using the Informatica integration service to run the workflows in 8.5.1
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Created user variables, property expressions, script task in SSIS.

Environment: ETL, SQL Server 2012/2008R2/2008/2005, SSRS 2012, SSIS 2012, Oracle 9i/10g, TFS, Tableau, Visual Studio 2012, XML, XSLT, MS Office, Visual source safe.