PROFESSIONAL SUMMARY:

• Having over all 5 years of diverse experience, which includes 1 year into Development and 4 years into Staff Augmentation experience.
• IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting Microsoft SQL Server.
• Expertise in SQL Server Integration Services (SSIS).
• Strong experience in design and developing ETL using MS SQL Server Integration Services (SSIS). Worked with various versions starting 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 and 2017.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional Table, Matrix, Chart and Sub Reports.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Derived column, Conditional Split, Bulk Insert, Merge and union all.
• Developing SSRS reports on SQL Server and have very good understanding of SSAS, OLAP cube and Architecture.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
• Worked Extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Good understanding of Data Warehousing concepts and ability to utilize star schema and snow flake schema according to the requirement.
• Experience in using T-SQL in SQL Server 2000, 2005and 2008 platforms.
• Experience in Performance Tuning and Query Optimization.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Experience with defect tracking and analysis using different defect tracking tools such as TFS (Team Foundation Server)
• Good knowledge of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake Schema Modeling.
• Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008/2012/2014/2016/2017, ORACLE

Scripting / formats: T-SQL, PL/SQL, C# HTML, XML

Business intelligence: MSBI Stack (SSIS, SSAS, SSRS), Data Warehousing

Analytics: POWER BI Knowledge, MSBI Self Service, MS Excel

IDE: SSMS, SSDT/ Visual Studio

Collaboration: MS SharePoint, MS Visio, TFS, JIRA, SVN, Confluence

Operating systems: WINDOWS, UNIX

Methodologies: Agile, SCRUM

PROFESSIONAL EXPERIENCE:

Confidential, Carmel, IN

MSBI Developer (SSIS, T-SQL)

Responsibilities:

• Currently, working on archival project to load the data into the data warehouse from different heterogeneous sources.
• Extracted the data from Oracle, Flat Files, transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed ETL package, with ETL Import/Export wizard for transferring data.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Ability to write complex SQL queries, stored procedures, functions and triggers to support complex business needs.
• Working with other ETL developers in the team to ensure smooth transition of data requirements into code.
• Analyzing data to understand business impact and proposing new changes and alternative solutions to existing data structures.
• Creating testing scenarios in Development environment to test and validate data integrity of the SSIS packages.
• Experience in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Experience in creating SSIS packages using Script task (Vb.net, C#) and Script Component.
• Have deployed packages on different servers by configuring them.

Environment: MS SQL Server 2017, Visual Studio 2015, MS SQL Server Integration Services (SSIS), MS Excel, T-SQL, SQL Query Analyzer, TOAD, Oracle DBMS.

Confidential, Nashville, TN

Junior SQL Developer

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Worked on advanced dimension Design and Cube design.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server (2003, 64-bit edition of SQL server 2000), DTS, Microsoft Business Intelligence Development Studio, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS.

Confidential, Pleasanton, CA

Sr. Account Manager / Business Analyst

Responsibilities:

Account/Client Management:

• Account Management/Delivery Management.
• With over all having more than 150 clients, I handled 27 Clients (mostly bay area clients) out of which few clients include BMS, Safeway, PG&E, Genapsys, PatientSafe Solutions, Linkbee, Endicia, CLoudVirga, NovaCredit, 12 Twenty, Chimpchange, Maverix Biomics, Veracyte, Nativo.
• Working directly with hiring managers on open positions to understand their needs, find the right candidates, interview and hire.
• Working with hiring managers directly on management of active consultants
• Detailed reports on open requisitions.
• Won weekly and monthly appraisals and best employee awards for my performance.

Staff Augmentation:

• Lead full cycle recruiting efforts including requirements gathering, sourcing, prescreening, interviewing, selection, negotiating compensation packages and closing candidates.
• Extensively/Committedly worked on hardcore JAVA, .NET, FRONT-END, DATACENTER and NETWORKING positions with having a huge database.
• Technically screened and Interviewed qualified applicants for technical skills, domain experience, relevant production experience as well as communication skills and cultural fit.
• Understand the Client’s/Vendor’s job requirements in depth from the VMS (Vendor Management System).
• Extensively worked/used ATS/Taleo/LinkedIn/Google groups/Greenhouse/Beeline/other social networking and side referrals.