SUMMARY:

• Over 8 years of SQL Server Development experience in SQL 2016/2012/2008 with an emphasis on design, development, automation, tuning, optimization, Performance and Security.
• Proficient involvement in end to end Development of Projects covering all phases of Software Development Life Cycle including Requirement Analysis, Designing, Build/Construction, Unit/Assembly Testing and Deployment.
• Extensive experience in SQL Server 2016/2012/2008 Business Intelligence tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Experience working on Tableau 9.x/8.x (Desktop, Server, Reader), creating various Reports and Dashboards using different functionalities.
• Experience in Tableau Desktop, Power BI for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Extensive experience in creating complex SSIS packages, creating jobs, Alerts and schedule SSIS Packages using SQL Agent, migrating the data from different legacy system to SQL using SSIS.
• Proficient in Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Handled various types of encryption and decryptions in SQL as per client requirements to secure data.
• Experienced in migrating Data from Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS).
• Expert in Creating, Configuring and Fine-tuning ETL workflows in SSIS.
• Hands on in Designing, maintaining and building Cubes, Dimensions, and Data source views, data mining Models, Deployment and Processing using SSAS. Proficient in writing MDX queries and use Client tools like Excel to provide visualizations on Multidimensional or Tabular Model Cube data.
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports.
• Good command in generating on demand and scheduled reports for business Analysis and Management decisions using SSRS 2016/ 2012/2008.
• Well versed in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008/2012.
• Developed Drill through and Drill down reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• Developed Python script to for processing large data sets and also to extract data from different files.
• Built Python Modules to deliver specific formats of data.
• Designed and developed OLAP Cubes with star schema and Dimensions using SSAS. Querying and manipulating multidimensional cube data through MDX Scripting.
• Expertise in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and processing SSAS objects.
• Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS)
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Meticulous involvement with management and development team to discuss productivity dash boards, client requirements and optimized technical glitches on a daily basis.
• Acquisition and master new technologies and to deliver outputs in short deadlines in a fast- paced environment with problem- solving and organizational abilities.
• A polished communicator, with good analytical and inter-personnel skills and versatile team player.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio 2016/2012/2008/2005 , SQL Server Data Tools (SSDT), Teradata Client

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

Reporting Tools: SQL Server Reporting Services ( 2016/2012/2008/2005 ), MS Access, MS Excel, Tableau 9.x/10.x, Power BI, MicroStrategy

Database: MS SQL Server 2016/2014/2012 , MS Access

TSQL, C, PL: SQL, Python

Other Tools: Ab Initio, Atana Suite, SQL Profiler, Cognos, Business Objects (BO), TFS, Putty, SAS EG

TECHNICAL SKILLS:

Confidential, San Francisco, CA

Sr Data Analyst

Responsibilities:

• Generated and Implemented MicroStrategy Reports by Creating Projects, Attributes, Hierarchies, Metrics, Filters and Templates using MicroStrategy architect
• Tuned Teradata SQL Statement using explain analyzing the data distribution among AMPS and Index usage, collect statistics, definition of indexes, revision of correlated subqueries, usage of hash functions etc.
• Worked on exporting data to flat files using Teradata Fast export, Teradata Parallel Transporter.
• Developed Teradata Macros, Stored Procedures to load data into incremental/staging tables and then move data from staging into base tables
• Worked on PMON/Viewpoint for Teradata to look at performance monitoring and performance tuning
• Use of Teradata manager, BTEQ, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
• Creating Dash Board Reports to view personalized reports based on company's requirements.
• Analyzing forecast performance over time and implementing model adjustments and refreshes when necessary
• Provide objective and analytical insights on key metrics, strategic initiatives, competitive/ industry factors, and performance drivers.
• Data Mining, Modelling, Cleansing, Record table linking, table structures and its implementations.
• Architecture impact on project, reviewing and providing the designs, communicating strategy to leaders and technology specialists.
• Organize, plan and prioritize the project in terms of its reliability and performance by fine tuning.
• Drive the execution of campaign performance reports to provide key learnings and feedback (trends, patterns, irregularity) for the marketing team

Environment: Teradata SQL assistant, Teradata Utilities, MicroStrategy, Tableau, Atana Suite, SAS EG, Putty, Microsoft Visual Studio, SQL Server

Confidential, San Ramon, CA

Sr BI Engineer

Responsibilities:

• Proficient involvement in design of Data migration project in end to end Development of Projects covering all phases of Software Development Life Cycle including Requirement Analysis, Designing, Build/Construction, Unit/Assembly Testing and Deployment.
• Following agile pattern, and communicating with functional and technical team on the requirements for migrating data from legacy heirloom systems to Hybris
• Creating staging DB, move all the business scope data to the staging database and migrate to Hybris using SSIS
• Developed interfaces to process the SAP Sales Orders, SAP Accounts, Shipping acknowledgements and ASN confirmation.
• Worked on dimensional modeling and maintained dimensions like Product, Customer, and Region as a part of Snowflake schema and loaded the data in the member fact tables.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources based on design data models.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, for loop and For Each Loop Container, Execute-SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Involved in Functional testing, cut over plans to discuss on the technical status of the launches
• Performed End-End testing includes various phases like SIT (System Integrations) Soft Launch, Pre production Launch, Going live and phased migrations
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the SSAS Tabular Models.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources based on design data models.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task, conditional Split, Script Component, Merge and Lookup while loading the data into Destination.
• Loading flat files every day and storing them in Archive by renaming the files with current date.

Environment: Microsoft SQL Server, visual studio, SSRS, SAP -Hybris, MuleSoft. .Net, GIT, Jira

Confidential, New York, NY

Sr BI Engineer

Responsibilities:

• Involved in design and analysis sessions with business analysts, system technical teams, and end users.
• Experience in all phases of Data warehouse life cycle involving analyzing, developing, designing, testing, maintaining Software applications and implementing Data Mart, Data Warehouse applications and Data integration using ETL
• Clear Over view on Data Warehousing concepts with emphasis on ETL and life cycle development.
• Experience in identifying bottlenecks in ETL Processes and Performance tuning of applications using Database Tuning, Partitioning, Index Usage, and Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Modifying data with SQL and Python in performing analysis, and developing visualizations
• Responsible for developing and maintaining ETL jobs
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments.
• The project involves extracting data from medical/claims dataset using queries, transforming the data using python.
• Sourced the data from XML files, Flat files, SQL Server tables and Oracle tables, business objects.
• Actively participated in ETL testing of the application by writing test cases, testing scripts for the Unit, System and Performance testing.
• Various ad-hoc Reports generation and developed unit test cases for system integration testing.
• Hands on experience using query tools like TOAD, Oracle SQL Developer, SQL Server Management Studio.
• Exposure in other OLAP tools like Business Objects, SSRS for developing Reports.
• Created UNIX scripts for FTP and SFTP files to different servers
• Worked with legacy and current data.
• Worked on dimensional modeling and maintained dimensions like Product, Customer, and Region as a part of Snowflake schema and loaded the data in the member fact tables.
• Created & formatted cross-tab, conditional, drill-down, drill through, summary, form, sub reports, parameterized reports, interactive reports & custom reports.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, for loop and For Each Loop Container, Execute-SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Involved in creating database objects like tables, views, procedures, triggers, and functions, joins, correlated and non-correlated sub-queries, indexes, normalization techniques using T-SQL to provide definition, structure and to maintain data efficiently.
• Designed and created data extracts, supporting SSRS, Power BI visualization reporting applications

Environment: MS SQL Server 2012/2016, Business Objects, Cognos, SSDT, Microsoft Access, Python, Team Foundation Service (TFS), Visual Studio 2017/2010, Power BI.

Confidential, New York, NY

Sr ETL Developer

Responsibilities:

• Involved in Agile methodology to meet requirements, gathering, analysis, planning, developing &testing
• Interacted with end-users and functional analysts to identify and develop Business Specification Documents (BSD)
• Involved actively in documenting the Technical specifications for the services to be implemented.
• Extensively used Slowly Changing Dimension (SCD) technique in insurance application.
• Expertise in OLTP/OLAP System Study, Analysis, E-R modeling, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Implemented Stored Procedures, Functions, views, Triggers, Packages in T-SQL.
• Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Created package to validate, extract, transformation and load data to centralize SQL Server using OLEDB providers from existing data source
• Worked on creating client reports and custom reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc.) using SQL Server Reporting Services 2012 and 2016.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Deployed and Generated SSRS reports using the Reporting Services and Report Manager.
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups
• Designed and created data extracts, supporting SSRS, Power BI visualization reporting applications.
• Created Datasets in T-SQL, stored procedures for SSRS.
• Created SSIS packages to import data from Excel, XML, OLE DB Source and Flat Files.
• Designed, built and tested SSAS Cubes on SQL Server.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector
• Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
• Designed and implemented Row Level Security & Roles for SSAS Tabular Model. And deployed into SQL SERVER ANALYSIS SERVER 2016.
• Created Excel workbooks to enable Cube (SSAS) access for business users.

Environment: MS SQL Server 2012, JIRA, SSIS, SSRS, SSAS, Team Foundation Service (TFS), Visual Studio 2017/2010, .NET, Power BI.

Confidential

SQL Server/ SSIS Developer

Responsibilities:

• Analyzing the FTA’s and the business requirements and building logical and physical data models.
• Creating high level design of the ETL process and data mapping.
• Creating three step ETL process to get the files from the server and load the data into database.
• Designing several ETL processes to Load data from Text or Excel Files
• Extensively used T-SQL, My SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL, My SQL
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Designing of SSIS Packages to get data files from FTP and SFTP Server and decrypting the PGP files, batch processing of incoming data and purging of old files
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling to move data from oracle to SQL Server.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2005.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Worked with different methods of Logging in SSIS.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created complex Stored Procedures to validate and process the incoming data.
• Generating Validation Reports to notify the client with the invalid data received.
• Used C# to merge multiple XML reports, convert XML to HTML format using XSLT files and sending Validation Report emails.

Environment: SQLServer2008, Oracle, MS Access, Excel, IIS, Java Scripts, SSRS, SSIS, C#, Oracle 9i/10g, Erwin.