SUMMARY

• 12+ years of experience in IT in Health Care, Insurance, Banking, Audit and Advisory, Mortgage, Real Estate domains.
• BI Consultant Role for providing design solutions and development of SSIS packages and SQL Server Objects.
• Project Manager (development) - handling complete development area comprising of ETL and SQL teams of size 10 including 6 developers and 4 onsite
• Possess strong knowledge in Software Development Life cycle (SDLC) processes such as AGILE Methodology, Waterfall Model etc.
• Involved in project life cycles such as Initiation, Analysis, Planning, Implementation, Maintenance and Support working directly with business, vendors and clients.
• Have experience working on T-SQL using SQL Server 2000/2005/2008/2008 R2/2012/2014 and Postgre SQL 9.6.
• Have experience designing, developing, configuring, error handling and deployment of SSIS ( 2005/2008/2012 ) packages to validate, extract, transform and load data to data warehouse tables (Dimension/Facts) and populate data marts.
• Have experience configuring SSIS auditing framework and monitoring of SSIS packages using third party tool BiXpress.
• Have experience working on SSRS reporting tool, creating sub reports, parameterized reports, cascading reports, drill down reports, drill through reports and interactive reports
• Have experience with SSRS configuration, SSRS subscriptions, deployment and use of report manager to grant or restrict user access to reports.
• Successfully demonstrated strong problem-solving skills, decision making capabilities and ability to motivate and guide team members to work in highly ambiguous & chaotic situations to draw out client requirements for IT implementation also possess excellent communication skills.
• Responsible for regular status reporting to upper management and clients.

TECHNICAL SKILLS

Operating Systems: MS Windows NT/ 2000/ XP/ 7/10

Databases: PostgreSQL 9.6, MS SQLServer 2000/2005/2008/2008 R2/ 2012/2014, PL/SQL (Oracle SQL Developer)

Tools: MSBI - SSIS 2005/2008/2012 , SSRS 2005/2008Tableau 10.2.1, DTS, VSTS 2005/2008/2010/2017 TFS, VSS, Crystal Reports, MS Visio

Software: .NET (ASP.NET in C#), Visual Basic 6.0, Java script

PROFESSIONAL EXPERIENCE

Confidential

BI Consultant / ETL Developer

Responsibilities:

• Creation and modification of SQL objects Stored Procedures, Views, User Defined Functions, along with writing T-SQL queries in SQL Server and Postgre SQL.
• Worked as Tableau Server Admin, by granting site admin roles, creation of server groups for Tableau Users.
• Improve performance management by fine tuning and optimizing SQL queries by modifying existing Stored Procedures and Functions.
• Creation of SSIS packages to read the data from various client sources and load the data into target server for Tableau Reporting.
• Responsible for weekly deployments in PROD environments.
• Ensure proper creation of Change Requests to ensure PROD deployments happens correctly.
• Adhere to coding standards and ensure flawless defect free code delivery.

Environment: Microsoft SQL Server 2014, Microsoft Visual Studio 2017, Postgre SQL 9.6Tableau Desktop 10.2.1

Confidential, Dallas, Texas

SQL Developer / BI Project Lead

Responsibilities:

• Responsible for ensuring Data Governance which included Data Security, Data Lineage, Master Data Management (MDM) and Data Loss Prevention (DLP).
• Debug and perform analysis of Cognos Run as xml file to identify stored procedures and queries used within the reports.
• Work on adhoc reporting requests with modification and creation of PL/SQL objects to meet business requirements.
• Ensure proper change management by acting as a Change Initiator, Change Activator to facilitate flawless deployment into different environments with proper tracking.
• Ensure proper logging of defects in defect tracking system (ALM).
• Ensure deployment details (dates, environment details etc) properly set in deployment tracking system called UTRN before each deployment cycle in QA, SIT and PROD.
• Provide P3 level support for production issues, responsible for identifying, fixing and providing complete status of the issue to concerned stakeholders.

Environment: Oracle SQL Developer (3.2.2), Cognos Report Studio

Confidential, Lewisville, Texas

BI Developer

Responsibilities:

• Ensure successful completion and delivery of daily/monthly reports (FHA AOP Curtailments, NStar paid claims reconciliation FNMA, Servicing Book, GNMA Treasury Report, MGIC SS 3rd Party Sale, Genworth SS 3rd Party Sale, MI Active, Zero upb Report).
• Design and develop excel macro reports to meet business needs.
• Automation and scheduling of claims reports as per business specifications and deadlines.
• Provide timely and accurate data analysis for any business requests made.
• Ensure to meet business needs with optimal report designing and solutions.
• Design and develop reusable SQL code to span its use across multiple reports.

Environment: SQL SERVER 2008 R2, Adtempus (Tool for scheduling and monitoring excel macro reports).

Confidential

MSBI Project Lead / BI Developer

Responsibilities:

• Design SSIS packages to load data from various sources with transformations, cleansing and validations applied to data before loading data into target environment.
• Implemented use of various sources like OLEDB, Excel, Flat File, Xml etc.
• Implemented use of various transformations like Lookup, Multicast, SCD, Data Conversion, Conditional Split, Script Component etc.
• Design and Develop SSIS packages for various personal lines LOB’s (Personal Auto, Home Owners, Package Policy, Dwelling Fire etc).
• Design and developed parameterized report in SSRS for HARTFORD financial reconciliation.
• Ensure fixes for PRODUCTION bugs within stipulated time frame.
• Prepare estimates of the work projected.
• Prepare deployment artifacts for (Model Office/UAT/PROD) environments along with deployment deliverables and work with DBA to ensure successful deployment.
• Perform Peer to Peer code reviews and unit testing of the code developed.

Environment: SSIS 2008, SSRS 2008, MS SQL Server 2008, TFS 2010

Confidential

System Analyst / BI Project Lead

Responsibilities:

• Involved in preparation of database Unit Test Cases for SQL Server objects using Microsoft Visual Studio 2010 DB Projects.
• Coding and Unit Testing of Modules developed.
• Conducting System and Regression Testing.
• Design and develop dashboard by automating SSRS reports (parameterized, conditional, cascading and drill down reports) and made use of SSRS subscriptions to configure mails for sending dashboard report to customer, also created custom function to achieve desired functionality.
• Responsible for task assignment, estimation and allocation to team members.
• Proper co-ordination with team members to ensure completion of assigned tasks within stipulated time.

Environment: SSIS 2008, SSRS 2008, MS SQL Server 2008/2008 R2, TFS 2010

Confidential

Sr. Software Engineer / Software Developer

Responsibilities:

• Ensure successful integration of Mailroom operations within FAZAL.
• Ensure successful integration of Workflow and FAZAL.
• Exposure to FACETS front end and back end modules.
• Responsible for ensuring Information Governance to meet regulatory requirement of data (HIPAA Complaint), implementation of data in regulated environment, high level of security access to data, apply governance policies to remove redundant data to reduce costs and risks.
• Taking feedback from data hub / FACETS back to FAZAL.
• FAZAL will Map Business goals across People, Process and Technology and provide significant value - additions at little or no additional costs.
• Worked on development of data entry application (Fazal) in .Net application capable of handling all mailroom operations.
• Design and develop SSIS packages to extract data from sources (CMS,UAC,Employee,SPAP)
• Design SSIS package with extensive use of transformations like script component, lookup, data conversion, derived column, multicast, merge join, union all, sort, SCD etc to in corporate all business logic.
• Responsible for generation and validation of MMS (Membership Maintenance System) feed generated out of FAZAL application.
• Ensure proper coordination with Facets team to ensure MMS feed sent out by FAZAL application doesn’t have any discrepancies, in case of any instruct team to make necessary updates to the data and regenerate the MMS feed.

Environment: SSIS/SSRS 2005, .NET (C#), MS SQL Server 2005, Java script, HTML, VSS, Visio.

Confidential, Huston

Software Developer

Responsibilities:

• Involved in preparation of Maintenance Change Request document based on requirement gathering carried out for the project.
• Providing technical inputs for jigs & fixtures and getting actively involved in enhancing features of existing products.
• Worked on front and back end on Facets module, to understand the generation of MMS feeds.
• Provide ongoing production support for the project from offshore.
• Developed DTS packages to extract data from various sources (CMS, UAC, Group Enrollments and SPAP) with implementation of transformations to handle all business logic.
• Develop modules using Active Server Pages, Java Script to design modules in Medicare part D project with backend database in SQL Server 2000.
• Ensure creation of estimation effort and unit test case preparation before starting with development of any modules.
• Was responsible for defect prevention tracking within the project and conducting monthly defect prevention meeting with the team.
• Was responsible for conducting knowledge transition meeting with team, in which project SME’s transfer the knowledge with team.

Environment: DTS, ASP (Active Server Pages), MS SQL Server 2000, Java script, HTML, VSS

Confidential

System Officer / Database Administrator

Responsibilities:

• Handling Financial / RTGS applications independently.
• Maintaining and developing Database Servers of internal applications for the bank.
• Actively involved in Disaster Management of RTGS application, independently installed RTGS application on cluster servers and was responsible for ensuring the flow of funds from RBI.
• Was responsible for vendor management to coordinate with vendor in case of any issues with servers, applications (RTGS, Kastle).
• Developed VB project for loading financial data from (RTGS, Forex, investment banking) into Microsoft Access database.
• Developed Crystal Reports to pull the financial data on bi-weekly basis and send across to management for analysis.

Environment: Visual Basic 6.0, Microsoft Access, Crystal Reports