SUMMARY

• 8+ years of experience in developing BI applications utilizing SQL server, Power BI.
• Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as SQL Server, Oracle, DB2, and MS Access.
• Hands on experience with various transformations such as lookup, conditional split, multicast, Derived column, merge, for each, for loop, Multi - cast, sorting, Data profiling, Bulk insert, Sequence container, Delayed validations etc. in Integration Services development.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Fact and Dimension tables.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions.
• Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands.
• Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Experience in managing and automating control flow, data flow, events.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Experience in Design, development of Business Intelligence Solutions using Tableau.
• Thorough understanding on connection managers, Checkpoint, Transactions, logging etc.
• Created Drill through reports, drill down reports, Sub reports, Cascading Parameters, Linked reports, Matrix etc. using BIDS.
• Expertise in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export etc.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C, HTML, DHTML, XML, VB.NET.

Database: MS SQL Server, MS Access, Oracle, DB2.

Database Tools: SQL Server Management Studio, Oracle SQL Developer.

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Service (DTS).

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report builder.

SQL Server Tools: SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS), SSAS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP &OLTP, Adobe Photoshop.

OS: Windows 10, Windows 2008, 2003R2, Windows Server 2008, Windows XP, Windows Vista, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, MA

SQL BI DEVELOPER

Responsibilities:

• Created various SSIS packages for data migration which processes multiple flat files coming from SFTP server and loads into different database tables.
• Developed SSIS packages to load data from staging tables to landing tables and then final tables.
• Involved in extracting the data from flat files in the development server and loading the clean data into the production server using SSIS
• Developed stored procedures for onboarding new practices.
• Trouble shoot existing packages and stored procedures.
• Deployed SSIS packages to multiple environments.
• Designed and implemented Stored Procedures for automating tasks.
• Tuned complex SQL Queries.
• Manually pulled data from different practice management systems.
• Involved in client meetings while onboarding new practices.
• Created daily status reports of data load and sent out to team.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Created mapping documents for existing stored procedures.
• Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages.

Confidential, Providence RI

SQL BI DEVELOPER

Responsibilities:

• Involved in statewide implementation of a new court system called Odyssey.
• Odyssey Case Manager is a web-based application that is designed to handle and track all aspects of court administration, from e-filing through disposition, and manage highly sensitive data.
• Prepared technical/functional specs and documented changes/ new developments and user training. Analyzed data based on business requirements.
• Developed Stored Procedures/ complex SQL queries for generating reports.
• Analyzed the performance, tuned and optimized the complex SQL queries using SQL profiler.
• Extensively used Joins and Sub-queries for complex Dynamic SQL queries involving multiple tables from different databases.
• Designed/ deployed/ published all types of SSRS reports like tables, drill thru matrix reports, charts, sub-reports etc., as Enterprise Custom Reports in Odyssey in different environments.
• Extensively used query and report parameters in the SSRS reports and dashboards.
• Developed and deployed Monthly, Quarterly, Half-Yearly and Yearly SSRS reports and created and maintained multiple subscriptions.

Confidential

HR Ops specialist

Responsibilities:

• Effectively handled production issues in project, analyzed the problems and provided effective solutions to the Customers.
• Able to learn new systems quickly, to have better technical and functional skills in handling activities.
• Played as Key Knowledge Person in the team on functional HRMS with respect to Data Management, Security, and Reporting in PeopleSoft.
• Two years of Knowledge as PeopleSoft Administrator mainly HRMS modules on Oracle Databases and their supporting Operating Systems.
• A wide knowledge on PeopleSoft Project Life Cycle, security objects (Roles, Permission list, user Profile, Maintain Security etc.
• Effectively Migrated the Cognos Security support from the customer via net meeting and created all the required process documents.
• Manage the day-today operations of the HR Application support team during the Performance & Compensation
• Evaluation Cycle.
• HPD ( Confidential Performance & Development) & GCP (Global Compensation Planning) process enhancement by taking inputs & feedbacks from Operation Team & share the requirements with HRIT to work on Enhancements from the technical aspects.
• Involved in Dev, QA & Development Testing for the process enhancement and share findings and key analysis with Operations & HRIT team.
• Gather Business Requirements for HRMS Applications from business partners and translate them to functional requirements for cross functional teams.