OBJECTIVE

• To work in pragmatic way in an organization where I can show my talent and enhance my skills to meet company goals and objective with full integrity and zest.

SUMMARY

• Over 7+ years of IT Experience in Database Administration, Data Warehousing, Database Design and ETL Processes in the Development, Test and Production Environments.
• Good hands of experience in Database Design, Development and business intelligence of Microsoft SQL Server 2016/2014/2012/ 2008/2005.
• Over 2+ years of experience on working with RPA technologies like Automation Anywhere and UiPath .
• Experience in design, development, testing and deployment of bots using Automation Anywhere.
• Experience in working on control room in running and scheduling tasks , monitoring, administrating bots and creating license allocation to the client users with respective roles.
• Implemented features like Task Recorder, Smart Recorder, and Web Recorder for existing robots and reduced the time of Task development using Automation Anywhere.
• Good Knowledge in Citrix automation , keystrokes, OCR, PGP, PDF integration, FTS/SFTP and If/Else commands, SAP BAPI Manager, Excel and Email Automation.
• Strong knowledge on usage of various OCR engines like ( ABBY, MODI and Tesseract).
• Hands on experience in producing/consuming web services and APIs - REST, SOAP
• Expert Knowledge of Microsoft BI Stack i.e. Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses using SSIS.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Developing reports on SSAS & SSRS on SQL Server (2005/2008/2012/2014 ).
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSDT or SSDT-BI.
• Expertise in creating and testing Stored Procedures, Triggers, Reports and Packages and writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in migrating data from external system including flat files, excel, MS Access and Oracle into SQL Server using SSIS/DTS packages.
• Hands on experience in installing, configuring, managing, upgrading and monitoring and troubleshooting SQL Server 2008/2012.
• Experience with Ad hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Experience working on Power BI with Power View and Power Pivot .
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expertise in designing Data Flow task and Work Flow task on SSIS.
• Experience in Dimensional Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.

TECHNICAL SKILLS

Databases: SQL Server 2016/2014/2012/2008/2005/2000 ,Oracle 10g/9i/8i/7.x, MS Access, DB2, MySQL, PostgreSQL

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, Database Tuning Advisor, SQL Profiler, Enterprise Manager, Query Analyzer, Erwin Data Modeler

BI Tools: Data Transformation Services (DTS), SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS), Tableau

Robotic Process Automation Tools: Automation Anywhere, UI Path

Programming Languages: SQL, T-SQL, PL/SQL, C, C++,C# .Net, Asp .Net

Operating Systems: UNIX, Windows (NT/2000/XP/Vista/7/8/10), Windows Server (2003/2005/2008/2012 )

Web Development Tool: HTML, XML, JavaScript, CSS, PHP, Python

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA /RPA Lead Developer

Responsibilities:

• Providing thought-leadership around solution / industry framework etc.
• Working as a RPA Lead Developer on Automation Anywhere and UI path.
• Hands-on experience in Robotic process automation solutions and control room features by allocating licenses to the bot creators and bot runners.
• Used various actions like Conditions and Loops, User prompts, Error Logging and commands like Object Cloning, OCR , Key Strokes etc., for coding the automation process.
• Develop bots using Automation Anywhere and Identifying and debugging the errors using Error Handlers.
• Performed Image comparison using Image recognition command and consumed Microsoft vision API for extracting handwritten text from an image.
• Partnered with developers to automate manual processes, saving time and money while decreasing errors. Credited as a primary driving force behind a 5% increase in margins this fiscal year.
• Worked on different Licenses in Automation Anywhere, like Development Client License, Run Client License, Control Room License.
• Identify opportunities to optimize application data models for performance, manageability, scalability and availability.
• Implemented Report Designer with commands like Task run, Workflow run, Task timeline, Workflow timeline and ROI.
• Experience in using Send Email Commands to Email reports and errors.
• Experience in using Delay and Wait commands.
• Worked on Activities using Object cloning and Manage Web Controls.
• Migrating SSIS Packages from SSIS 2008 to SSIS 2012/2014.
• Perform database administration activities such as storage management, backup and recovery.
• Migrate Database Servers from SQL 2005 to 2008, 2012 and 2014.
• Maintain availability and integrity of databases through multiple access schemes; facilitate sharing of common data by overseeing proper key and index management and data dictionary maintenance.
• Contributes improvements of the databases/database environment.
• Guiding in planning technical validations and testing strategy on complex solutions.
• Providing expert guidance in leveraging re-usable components and help manage the solution risk.
• Involved in End to End development of Business Process using Robotic Process Automation.

Confidential

SQL Developer/DBA

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Worked on Entity Relationship Diagrams and modifying them.
• Created SQL joins, Sub queries, tracing and Performance Tuning for better running of queries.
• Designed different type of reports including: Tabular, Matrix (cross Tab report), List items, Charts and Linked reports.
• Created and designed reports based on query parameters and Report parameters.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions to migrate data from staging to production environment
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse Worked on SSIS script task, look up transformations and data flow tasks using T- SQL .
• Generated Custom ETL scripts using SSIS, develops and unit test SSIS load processes for performance check.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Confidential

SQL Developer/DBA

Responsibilities:

• Develop ETL Packages and Reports.
• Create tables, stored procedures when required.
• Served as the primary point of contact for most of the Enterprise Business intelligence design and development.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Used Team Foundation Server (TFS) for version control, source control and reporting.
• Extensively worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
• Hands on experience in using different transformations like data Conversions, lookups, Derived column transformations etc. for data cleansing to remove unnecessary columns, eliminate redundant, inconsistent data and unnecessary Data like removing empty rows using SSIS.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Create databases, tables, and fields for data entry, performing database capacity planning.
• Enhancing and deploying the SSIS packages from development server to production server and scheduled jobs. Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed Stepped and Block reports using SSRS.

Confidential

SQL BI Developer/DBA

Responsibilities:

• Gathered requirement and designed technical document to implement the application.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives.
• Created functions and developed procedures to implement application functionality at the database side for performance improvement, involved in Performance tuning of Queries, Indexes and Stored Procedures using SQL Profiler.
• Successfully tested all task in staging and stored all versions of data using Team Foundation Server (TFS).
• Experience in designing Database Models for creating tables, indexes, optimizing views using MS Visio .
• High Level Design of ETL SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Flat file, Text Format Data).
• Involved in ETL framework standards like error processing, reconciliation, and validation.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Business Intelligence reporting using Excel with PowerPivot.
• Worked on Excel 2010, PowerPivot for providing ad-hoc reporting for the clients.
• Designed and developed SSIS Packages to extract data from various data sources such as MS Access database, Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2008 to SQL Server 2012.
• VB Script has been written for scripting the task in SSIS packages.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS ).
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services.

Confidential, Virginia Beach, VA

SQL Developer/DBA

Responsibilities:

• Worked with business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Handling reporting team and resolving their issues.
• Created reports using SSRS for revenue, Sales and demand.
• Generated Sub-Reports, Drill down reports and Parameterized reports using SSRS
• Created Data Driven subscriptions.
• Worked on ETL to integrate and analyze data from multiple Sources
• Created Deployment utility to deploy SSIS packages.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Responsible for the Performance tuning of the Complex SQL Queries with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Responsible for Testing and Debugging the Stored Procedure, SQL Scripts, SSIS package and Reports.
• Worked in on site/ off shore environment; coordinated my activities by proactively communicating with my counterparts in the off shore team and working closely with my manager.
• Experience working in agile environment and supported iterative testing methodology.

Confidential

SQL Developer

Responsibilities:

• Experience in working with SSIS for Data integration services. Expert in extracting and transforming data using SSIS Import/Export, SSIS Import Export Data, SSIS Packages, Bulk Insert and BCP.
• Highly capable in developing and monitoring SSIS and SSIS packages for using it in regularly scheduled jobs to extract, modify, or transform data for a variety of purposes.
• Experienced in developing User reports and management reports using SQL Server Reporting Services (SSRS).
• Efficient in creating reports with complex formulas and to query the database for Business Intelligence.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Demonstrated ability to write testable SSIS maps in the SQL Server 2008 environment or greater.
• Demonstrated experience with organizing techniques when dealing with a large library of SSIS scripts.
• Collaborated with test teams who ran the SSIS maps during test and validation phases of a project.
• Expert in developing ETL packages with different data sources (Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).