SUMMARY

• Having 10+ Year of Experience in BI tools and SQL Server integration services (SSIS) for ETL (Extraction, Transformation and Loading), SQL Server reporting services (SSRS) for creating different types of reports using SQL query’s and analysis services (SSAS) for design and developing complex cubes and MDX query’s, Tabular Module DAX Query’s.
• Strong Experience with SSIS Designer, Runtime Engine, Data Flow Task, Transformation, Pipeline & and Executables, define and maintains database objects.
• Well versed with the knowledge of RDBMS concepts and experience in writing joins, sub queries, indexes, views, complex CURD stored procedures, trigger and function using SQL Server, data warehousing i.e. OLTP & OLAP systems.
• Expert in writing T - SQL, data migration for DTS 2000 (Data transformation services) packages to SQL Server 2005/2008 using ActiveX script task to support business logic in packages, data cleansing, data scrubbing.
• Expert in understanding and querying complex Oracle databases (10g/11g) as well as an ability to understand the business rules that apply to the data.
• Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, database analysis, database management and enhancement, user authorizations and database creation.
• Excellent experience in Kimball and Inmon modeling techniques.
• Expert in STARS and Snowflake data warehouse modeling, Fact & dimensional data modeling for Analysis server using SSAS (cube, Measure, partitioning, optimization, aggregations).
• Experience in providing SSRS server level, item level security, roles & accessibility to various reports in multi-user environment.
• Excellent in creating Power BI dashboards and SSRS reports cross-tab, conditional, drill-down, top n, summary, form, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports.
• Experience in PL/SQL, Infosys,Sybase, Informatica,CA DB2, Oracle Apps, SAP BI, Oracle SQL plus, Delphix Virtualized Data, Forms & Reports 6i, 9i & 10g SQL Server 2005/2008, Compuware File-AID, Toad tool, SCM tools, Confidential, HTML, XML, and JIRA tracking tools, analysis, design, implementation and administration of business intelligence solutions with Microsoft SQL server 2012/2008/2005 in development, testing & production.
• Exposure to all phases of software development life cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.
• Experience in composite applications using Service-oriented architecture (SOA).
• Excellent communication, analytical skills, self-learning abilities and leadership quality.
• Excellent strong analytical and problem solving skills in designing, developing, and implementing innovative business process, Business Objects and providing system solutions using new approaches, technology and training.
• Solid understanding of PL/SQL and ability to write scripts to automate and manage data, performance tuning, SQL Query optimization and Drive to automate process and procedures which are manual.
• Domain experience in Capital Market, Banking, Healthcare, Transportation, Property Management.
• Excellent in Big Data Hadoop, SAP HANA, Vertipaq (In-Memory) database, Kyvos, Collibra, Spark, Snaplogic, Power BI,Tableau, Microstrategy, data analysis and visualization.
• Experienced in interacting with business users/ partners/ Stakeholder to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• MS-SQL DBA experience with Migration & Up gradation.
• Strong Experience with MS Analysis Services SQL Server Import/Export Wizard.

TECHNICAL SKILLS

DBMS/RDBMS: MS-SQL Server 2016/2014/2012/2008 r2/2005/2000, Oracle Database 11g/10g/9i, T-SQL, PLSQL,SQL Loader.

BI ETL & Reporting Tools: SQL Server Integration Services (SSIS), SSAS (MDX,DAX), SSRS, BI, Tableau, HP Vertica database, MDM(Master Data Management ), MDS, DQS, Data Mart, Microstrategy,T-SQL using CURD Stored Procedures, indexing, aggregation, pivot queries, query optimization.

Tools: Visual Studio 2016/2014/2012/2008 , Toad, Reporting Services, JIRA Tracking tools.

Languages: C, C++, PL/SQL.

Database Connectivity: ADO.NET, OLEDB, and ODBC.

Front End: ASP.net, C#, HTML5, CSS3.

Web Knowledge: XHTML, XML.

Systems: Linux, Windows 7, XP, Vista, UNIX, Windows 2000, Windows NT, DOS.

Job Scheduler: Autosys.

Version Control Tools: - TFS, Confidential, SVN.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh NC.

Application and tools: SQL Server 2012/2014,IBM DB2,Infosys, Sybase, Informatica , Oracle PL/SQL, BIDS ( SSIS/SSAS/SSRS/MDS/MDM /DQS ), ESB, Power BI, Tableau, SAP BW,HP Vertica, Business Rule Systems inRule, asp, c#.Net , Language Integrated Query LINQ, MS SharePoint, Toad, MS Office, T-SQL, MS Excel, ERWIN.

Lead Business Intelligent Data warehouse Developer

Responsibilities:

• Create ETL SSIS packages and Invoke inRule (business rule management tool) through SSIS ETL package to evaluate data for cleansing.
• Create SSIS profiling package for data analysis and data profiling.
• Create physical / logical data model design for DMG Data warehouse (DWH) project and Workforce Database.
• Create ETL Mapping document and Technical specification document for mapping data elements, data flow.
• Create ETL for extracting data from Composite source system to staging repository for business analysis and data cleansing work.
• Translate data rules to complex sql queries for data validation and cleaning.
• Define Business Rules using InRule Engine.
• Created and maintained proof of concepts for all the SSIS ETL packages.
• Involve in OLTP and OLAP data modeling techniques and a demonstrated ability to interpret Entity Relationship Diagrams.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies, Multidimensional MDX query, Tabular Model DAX query based on the OLAP SSRS Reporting needs.
• Create Power BI Dashboard reports and (SQL Server Reporting Services)SSRS report type Parameterized reports,Linked reports, Snapshot reports, Cached reports, Ad hoc reports, Clickthrough reports, Drillthrough reports,Subreports.
• Use Master Data Services for data steward review and decision.
• Responsible for managing all the production deliverables (deployment document, Work Order, Change Order).
• Maintain the best practices and RDMS best concept for writing the SQL queries and maintain the ETL tools.
• Created C# .net tool for invoking InRule entities in SSIS component and pass the rules through inRule engine.
• Create test Cases for business scenarios for validation and testing.
• MS-SQL DBA experience with Migration & Up gradation.
• Define and maintains database objects.
• Work on Performance tuning (Data flow Query Tuning),Caching, Indexing, Sql Profiling to troubleshoot SQL queries.
• Involved in creating deployment document, Work Order, Change Order for production with DBA team.
• Resolve the QA/Production Issues.

Confidential, Charlotte, NC.

Application and tools: SQL Server 2014, Language Integrated Query LINQ, IBM DB2,Oracle PL/SQL, BI tool (SSIS/ SSRS /SSAS), T-SQL, Delphix Virtualized Data, Tableau, Toad, HP Vertica, Autosys, Pac2000, ERWIN, Linux, Windows.

Lead Business Intelligent Data warehouse Developer

Responsibilities:

• Gathering the project requirements during define and analyze phase for Confidential .
• Understanding the client requirements and convert the business requirement into technical detailed document.
• Impact analysis on the existing system due to upcoming development and align with the business partner for impact of new changes and identify their scope.
• Create data model design and ETL Mapping details.
• Creating SSIS ETL & SQL server packages, Stored Procedure, Convert data for analysis using SSAS and generate SSRS reports.
• Analyzed the requirements and finely tuned the CURD stored procedures to improve the performance.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs using MDX and DAX querys.
• Created C#.net application to get GL accounting entries from upstream Web application and evaluate data through Confidential application and pass to downstream systems.
• Constructed cubes based on data volumes mostly adhering to Star Schema.
• Create test Cases and deployment on production.
• Involve on Production Support.
• MS-SQL DBA experience with Migration & Up gradation.
• Define and maintains database objects.
• Responsible for managing the project deliverable and schedule.
• Work on Performance tuning (Data flow Query Tuning),Caching, Indexing, Sql Profiling to troubleshoot SQL queries.
• Attending onshore/offshore staff meeting and providing updates for Confidential project.
• Coordinates with offshore for developments task, and involves in coding, peer review, unit testing and system integration testing in developments phase.

Confidential, Warrensville Heights, OH.

Application and tools: SQL Server 2012, BI tool (SSIS/ SSRS /SSAS), IBM DB2,Oracle 11i, ERWIN, Toad, HL7 integration, Compuware File-AID, Rhapsody Integration Engine.

Sr. BI Application Consultant / SQL Developer

Responsibilities:

• Gathering the project requirements during define and analyze phase for Fazal Part D Process.
• Understanding the client requirements and convert the business requirement into technical detailed document.
• Impact analysis on the existing system due to upcoming development and align with the business partner for impact of new changes and identify their scope.
• Managing Data model design and preparing the ETL Mapping details for upcoming changes.
• Create Complex T-Sql Stored Procedure, ETL Packages and SSIS packages to import and export data.
• Writing the Store Procedure based and involves in optimize of the store procedure, tracking the store procedure performance periodically.
• Create SSIS and SQL Server packages for 2015 Group and Individual enrollment for enrollees to identify eligibility queue process.
• Creating batch process using SSIS packages for files Send and receive from Infox and DM46.
• Extracting data from a large variety of sources, transforming and loading to a SSAS database.
• Involve in OLTP and OLAP data modeling techniques and a demonstrated ability to interpret Entity Relationship Diagrams.
• Worked on C#.Net interface for Enrolment process.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting.
• Involve in the development for upgrade the application functionality and changes, based on the requirement.
• Responsible for managing the project deliverable and schedule.
• Attending onshore/offshore staff meeting and providing updates for Fazal part D project.
• Coordinates with offshore for developments task, and involves in coding, peer review, unit testing and system integration testing in developments phase.
• Responsible to provide data discrepancy report and solution for discrepancy.
• Work on Performance tuning (Data flow Query Tuning),Caching, Indexing, Sql Profiling to troubleshoot SQL queries.
• Report and fix the production issues to the client manager and take appropriate action to bring the issues to closure.
• Maintain the best practices and RDMS best concept for writing the store procedure and maintain the ETL tools.

Confidential

Application and tools: SQL Server 2008 r2 (T-Sql/SSIS/SSRS/SSAS/QlikView Tool in Target Pro 4.7), Compuware File-AID, Toad, IBM DB2, PLSQL, Data. Modeling Tool - Visio.

Sr. Business Intelligence Data warehouse SQL developer

Responsibilities:

• Gathering the project requirements during define and analyze phase for Construction portal data warehousing projects.
• Understanding the client requirements and convert the business requirement into technical detailed document.
• Impact analysis on the existing system due to upcoming development and align with the business partner for impact of new changes and identify their scope.
• Managing Data model design and preparing the ETL Mapping details for upcoming changes.
• Create Complex T-Sql Stored Procedure, ETL Packages and SSIS packages to import and export data.
• Using SSAS create dimensions, cube partitioning, optimization, aggregations.
• Extracting data from a large variety of sources, transforming and loading to a SSAS database.
• Writing Custom MDX query to create SSRS dashboards reports.
• Build Front-end Graphical user interface and report prototyping.
• Involve in OLTP and OLAP data modeling techniques and a demonstrated ability to interpret Entity Relationship Diagrams.
• Involve in the development for upgrade the application functionality and changes, based on the requirement.
• Create summary reports using pivot or crosstabs summary data.
• Work on Performance tuning (Data flow Query Tuning),Caching, Indexing, Sql Profiling to troubleshoot SQL queries.
• Responsible for managing the project deliverable and schedule.
• Attending onshore/offshore staff meeting and providing updates for Construction Portal data warehousing projects.
• Coordinates with offshore for developments task, and involves in coding, peer review, unit testing and system integration testing in developments phase.
• Responsible to provide data discrepancy report and solution for discrepancy.
• Report and fix the production issues to the client manager and take appropriate action to bring the issues to closure.
• Writing the Store Procedure based and involves in optimize of the store procedure, tracking the store procedure performance periodically.
• Maintain the best practices and RDMS best concept for writing the store procedure and maintain the ETL tools.

Confidential, NY

Application and tools : SQL Server T-SQL, IBM DB2, PLSQL, BI SSIS/SSRS/SSAS ETL Development.

Business Intelligence Data warehouse developer

Responsibilities:

• Developed Adhoc Queries for Finance department. Designed and Developed AR Reports, Daily Payment Reports, Ledger Reports using Oracle Toad Reporting Services for Data Analyst.
• Used SSIS for large Data Migration Tasks.
• Developed Statements, Invoices, Notices, mortgages and Violations that are sent to SunPass Customers.
• Designed and Developed Toad Reports and Stored Procedures for Audit and Finance departments to suit their needs.
• Integral part of the Production Support Team on a biweekly rotation basis. Modified existing complex analytical and ad-hoc queries to run faster using OLAP approach.
• Analyzed financial data using graphs and pictures in SSRS for predicting future data. The level of automation achieved due to deployment of this project helped the department view the entire MDX Turnpike Authority’s financial situation on a daily basis in real time and reduced considerable amount of manual work resulting in huge savings and efficient operations.
• Knowledge in designing and developing data warehouses, data marts and business intelligence using multi-dimensional models such as star schemas and snow flake schema for developing cubes using MDX.
• Deploying SSRS Reports to allow the business users to interact to those reports and implement securities for sensitive reports.
• Create Complex T-SQL Stored Procedure, ETL Packages and SSIS packages to import and export data.
• Create summary T-SQL reports using pivot or crosstabs summary data.
• Developed SQL and Oracle stored procedures and Packages and Scripts for reconciliation purposes for various divisions in MDX and developed Toad and SSRS Reports (approx. 240) and deployed to the server. Concerned persons are given access to the location where the reports are on the server so that they can run the reports themselves which helped minimize or eliminate unnecessary delays.
• Work on Performance tuning (Data flow Query Tuning),Caching, Indexing, Sql Profiling to troubleshoot SQL queries.
• Designed and Developed SRS Reports and Toad reports and Stored Procedures and Packages and Scripts using Oracle and SQL for Audit and Finance departments to suit their needs. This project helped the department to view the entire SunPass and Authority account’s call centers call volumes on a daily basis automatically and reduced considerable amount of manual work to Call Center Managers and Customers (Turnpike Authority).
• Designed Collections work flow and developed stored procedures and reports using Oracle and SQL.
• Performed detailed Data Analysis using DI tools to establish trends in current data for traffic and revenue to predict future forecast up to 12 months that helped effective budgeting and efficient resource allocation.

Confidential, NY

Database Maint AM BFSI BNFS Data warehouse developer

Application and tools: T-SQL, ETL -SSIS, MS SQL Server 2008 r2, IBM DB2,ORACLE PL/SQL,unix, Putty, toad

Responsibilities:

• Analyze the requirement and distribute work among the team.
• Design & Develop complex SSRS reports
• Create SSIS packages to data import and export
• Create database objects - tables, stored procedures, functions, views
• Deploy SSRS, SSIS objects into UAT/Production environments.
• Create Complex T-SQL Stored Procedure, ETL Packages and SSIS packages to import and export data.
• Create summary T-SQL reports using pivot or crosstabs summary data.
• Reduce Vendor Cost - Avoid duplication
• Reduce Operations cost and error - Avoid sending prices from system to system
• Minimize exposure - Same price from a given vendor for the same security across all systems.
• Improve Quality of Prices - Better system for selecting the best price utilizing pricing hierarchies
• Ensures price for each security - Every security receives a price even if one or more vendor feeds are not available at a given time.
• Ensure pricing of held securities - Avoid unnecessary research on securities that are not held

Confidential, Michigan

Software Engineer

Application and tools: PLSQL, Oracle Apps, Oracle Developer Suite 10g Forms & Reports, SQL Developer, Toad, Putty,, Unix.

Responsibilities:

• Developed a menu driven application to facilitate data entry and generate reports using FORMS and REPORT.
• Enhancement on the forms and creating a new forms and new report UI.
• Understanding the client requirements by studying functional document.
• Write SQL queries, Triggers, Functions, Procedures, cursors and Packages.
• Create summary reports using pivot or crosstabs summary data.
• Involved in the preparation of test data and Data setup for UAT support.
• Write the Scripts, compiles and executes.

Confidential

Sr. SQL developer

Application and tools: SQL Server SSRS/SSIS / SQL, PLSQL, Oracle Developer Suite 10g Forms & Reports, SQL Developer, Putty,Toad

Responsibilities:

• Understanding the client requirements by studying functional document.
• Enhance Existing forms.
• Write SQL queries, Triggers, Functions, Procedures, and Packages.
• Involved in the preparation of test data and Unit test Plan.
• Write the Scripts, compiles and executes.
• Developed Statements, Notices and Invoices that are sent to Pike Pass customers (approx. 500,000) every month automatically.
• Part of the Production support Team. Manage two servers. Taking Backups, Recovery and scheduling Jobs and Checking the Status of the Scheduled Jobs.
• T ake Care of the Online Payments Processing by the customers. Automatic scheduling the payment process every night that post into their accounts. In case of failure sending messages support team automatically.
• Converted number of existing eActuate and Crystal Reports to SRS 2003/2005. Modified and optimized all the existing (approx. 75) stored procedures including indexing to suit the coding requirements of SQL Reporting Services (SRS).
• Designed and Developed 200+ SRS Reports for Payroll, Pike Pass and Toll Divisions.
• Designed and Developed SRS Reports and Stored Procedures for Audit and Finance departments to suit their needs. This project helped the department to view the entire OTA’s financial situation on a daily basis automatically and reduced considerable amount of manual work.
• Designed and Developed Work Order in SRS Reporting Services for all OTA staff. This project helped the inventory department to be able to view the status of all supplies in just one report on a daily basis and maintain the stock more precisely and reliably.
• Used OLAP approach for future budgeting and forecasting, Marketing and Sales, Financials Reporting, Management Reporting.
• Developed stored procedures for reconciliation purposes for various divisions and developed Reports and deployed to the server. Concerned persons are given access to the location where the reports are on the server so that they can run the reports themselves.
• Created Automatic Subscriptions to the reports which run and email to the address in the subscriptions at a stipulated time on a daily basis to different departments.

Sr. SQL developer

Application and tools: PLSQL, Oracle Developer Suite 10g Forms & Reports, SQL Server SSRS/SSIS, Putty, Toad, Confidential .

Responsibilities:

• Worked as Software Developer, Understanding the client’s requirement and implement module in PL/SQL, Oracle Forms & Reports 10g. Prepare Unit test documents of the delivered product.

Application and tools: PLSQL, IBM DB2, Oracle Developer Suite 10g Forms & Reports, SQL Server SSRS/SSIS

SQL Developer

Confidential

Responsibilities:

• Worked as Software Developer, Understanding the client’s requirement and implement module in PL/SQL, Oracle Forms & Reports 10g, SSIS & SSRS. Prepare Unit test documents of the delivered product.

Confidential

Sr. Software Engineers

Application and tools: PL /SQL SUSE Linux Enterprise Server 9, Oracle Developer Suite 10g Forms & Reports, SQL Server SSRS/SSIS, Oracle 10g AS

Responsibilities:

• Master Maintenance -Schedule Master, Sub Schedule Master, GL Master, Currency rate master.
• Transaction -Opening Balance, Voucher Entry, Reverse voucher, bill passing, bank statement entry, bill Adjustment voucher.
• Reports-balance sheet, profit & loss Account reports etc.
• Worked as Software Engineers, Understanding the client’s requirement Programming on Oracle 10g, PLSQL with Developer 2000 forms 10g, reports 10g. Involve in functionality testing of the delivered product.
• Implementation of ERP software at different Client sites, giving User Training, Made new business area, modification in reports from Report 10g.

Confidential

Jr. Software Engineers

Application and tools: Windows 2003 server, Sybase, Oracle Developer Suite 10g Forms & Reports.

Responsibilities:

• Extensive interaction with business user for requirement collection and validation of the system Design of the User Interface, Business components developed various modules of application using forms, reports and PLSQL.
• Extensive system study and evaluation of system specification in consultation with the end user. Participating in the database design group, Continuous interaction with end user throughout software development life cycle.