SUMMARY:

• 7+ years of experience as SQL/BI Developer including requirements gathering, system study, analysis, design, development, deployment, production maintenance and support experience in various domains Financial, Retail, Banking, and Online Education.
• Strong work experience with Business intelligence tools, including Microsoft Business Intelligence Development Studio (BIDS).
• Experience working in an AGILE environment, participated in SCRUM and was able to successfully multi - task across a number of concurrent projects.
• Experience working with vendors designing and setting up systems for data integration.
• Experience in creating complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.
• Experience in Data Extraction, Transforming and Loading (ETL) using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML), package configurations and logging.
• Highly proficient in T-SQL creating tables, views, stored procedures, user defined functions, Views, CTE’s (Common Table Expressions) and Triggers.
• Proficient in using the SQL Profiler and Query Execution Plan review.
• Experienced with Performance Tuning, optimizing queries and stored procedures.
• Highly experienced in building dashboards, analytical and operations reports using charts, gauges, with sub report, drill down, drill through, multiple tabs, parameterized report features.
• Experienced in using multiple Control Flow and Data flow tasks and transforms like conditional split, lookup, sort, merge, data conversion, derived column etc. to build various SSIS Packages.
• Experienced in project focus areas like Data Warehousing, Business Intelligence, Reporting, Business Process Modeling and Data Modeling.
• Strong interpersonal and presentation skills with ability to coordinate cross functional groups to accomplish objectives and meet critical deadlines in a fast paced high growth dynamic environment.
• Initiative to learn the business processes & applications, value and intent of the project.
• Excellent understanding of all of the data available within the and how to leverage this data with business processes to interact with business users and analysts.
• Quick learner, with strong analytical and critical thinking skills. Ability to work to deadlines, with a results-oriented, flexible and adaptive approach to problem-solving. Well-organized, highly motivated, and effective.

TECHNICAL SKILLS:

Packages / Tools: MS SQL Server 2012, MS SQL Server Integration Services 2012 (SSIS), Microsoft Dynamics CRM, SQL Server Management Studio (SSMS), MS SQL Server Reporting Services 2012 (SSRS), Crystal Reports.

Programming Languages : C, C++, Visual Basic, UNIX Shell Scripting, SQL.

Operating Systems: UNIX, Linux, Windows, Microsoft DOS.

Databases and Related: Microsoft SQL Server, Oracle, Microsoft Access.

Version Control: Team Foundation Server 2008.

Other Applications: Microsoft Project, Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Microsoft Visio.

PROFESSIONAL EXPERIENCE:

BI Developer

Confidential, Fort Worth, TX

Responsibilities:

• Designed Provider Master Data Architecture.
• Developed Provider Master Data Services.
• Designed referral process to enable care management to auto approve medical claims, enabling faster processing for patients and physicians and saving cost.
• Automated the above referral process.
• Designed, developed and automated provider and patient’s reports based on various risk adjustments, diagnosis and procedure codes.
• To work on implementing projects to migrate enterprise claim processing for Providers legacy system to Trizetto QNXT
• To function as technical subject matter expert for QNXT system database related issues.
• To work directly with senior management and subject matter experts to understand their business needs, strategies, priorities and key issues
• To development of Business Requirement Documents.
• To reduce process implementation time by over 70% by streamlining and automating processes.
• To collaborate with Vendors such as Trizetto and TCS healthcare to implement the projects.
• To use SQL, SSIS and SSRS to analyze legacy systems data to assure compliance with business processes and a high level of data quality.
• To work on defining the source to target data mappings, business rules and data definitions.
• To mentor junior developers and providing ongoing technical support, leadership to new business implementation.
• To work in an Agile BI environment and successfully multi-task across a number of concurrent projects.
• To use SharePoint and SSRS to create a centralized dashboard of metrics that provided intricate detailed performance metrics, cost and goals used by Senior Management of the company.
• To work with Project Managers to develop project schedules for related projects and provide status updates to account managers.

BI Developer

Confidential, Addison, TX

Responsibilities:

• Responsible to maintain, automate, monitor and improve data integration processes by collaborating with architects, business analysts and subject matter experts.
• Responsible to streamline business processes within functional area by analyzing and resolving operational issues for daily processes and workflows.
• Used SQL, SSIS and SSRS to analyze legacy systems data to assure compliance with business processes and a high level of data quality.
• Develop reports using formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).
• Trained users to use Reporting Services.

DATA Integration Developer

Confidential, Downtown Dallas

Responsibilities:

• Responded to design issues with related groups such as Development, Database, Data Integration and Customer Support.
• Responsible to ensure processes run smoothly by analyzing application functions and features.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsible for analyzing and testing by writing SQL scripts and writing test cases.
• Developed SSIS Packages to integrate data in the operational data store.
• Used SharePoint and SSRS to create a centralized dashboard of metrics that provided intricate detailed performance metrics, cost and goals used by Senior Management of the company.
• Worked with Project Managers to develop project schedules for related projects and provide status updates to account managers.
• Created business test scripts and test cases as well as performed business testing.
• Participated on a cross functional team to develop ideas for continuous process improvement.
• Worked in an Agile BI environment and was able to successfully multi-task across a number of concurrent projects

SQL Developer

Confidential, Dallas

Responsibilities:

• Analyzed Procurement and Accounts Payable data to identify error trends and correlations.
• Analyzed technical specification as per business requirements.
• Created reconciliation reports using SSRS and VB.
• Analyzed payroll data using SQL Server and advanced MS Excel advanced features to find trends.
• Developed ad hoc reconciliation reports for compliance office using MS Access.
• Analyzed technical specification as per business requirements using MS Visio.

Software/ETL Developer

Confidential, Riverwoods, IL

Responsibilities:

• Undertook data warehousing for analysis of IVR and call routing system to increase utilization.
• Analyzed of technical specifications as per business requirement.
• Undertook Extraction, Transformation and Load (ETL) from multiple sources to data warehouse.
• Undertook unit testing and removal of bugs and errors.
• Monitor daily, monthly process required to maintain the large data warehouse.
• Undertook maintenance activities - creation, development and running graphs for ad-hoc requests.
• Conducted knowledge transition sessions on Unix Shell scripting and Ab Initio for junior resources.