Proactive ETL Developer with 10 years carefully handling and transforming data loads to suit customer needs. Versed in all dominant information modeling designs and mapping technologies. Dedicated to flawless ETL integrity and impeccable data security during all database maintenance and modification tasks. History of mining, warehousing and analyzing data at the company-wide level. Knowledgeable about the principles and implementation of machine and deep learning. Results-oriented and proactive with top-notch skills in project management and communication. Talented business intelligence professional bringing advanced understanding successful strategies for identifying, protecting and capitalizing on data assets. Constructs new systems to answer complex business needs. Highly-motivated employee with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills. Hardworking employee with customer service, multitasking and time management abilities. Devoted to giving every customer a positive and memorable experience.
● Installing and Configuring SQL Servers Analysis service on cluster environment.
● Involved generating reports like profit & loss statement and balance sheet statement for client.
● Identified and defined Key Performance Indicators (KPIs) in SSAS.
● Troubleshooting failed jobs daily and fix them.
● Proactively monitoring and identifying the problem queries and missing indexes.
● Working with Application Teams and third-party vendors to setup a new database environment for the new apps.
● Working on Built and wrote, calculated members.
● Developed custom reports and distributed Reports in multiple formats.
● Working on linked dimensions.
● Extracting data from .txt files and importing into SQL Server monthly once using import/export Wizard.
● Resolving problem/incident tickets based on their priority and working with end users to get them resolved as quickly as possible.
● Responsible for planning Database backup strategy and Disaster Recovery procedures.
● Built and wrote MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server Analysis Services Business Intelligence (SSAS, SSRS).
● Troubleshooting CPU bottlenecks and Memory bottlenecks
· Monitor the Database for duplicate records. Merge the duplicate records and ensure that the information is associated with company records.
· Standardize company names, addresses, and ensure that necessary data fields are populated.
· Review the database proactively t3identify inconsistencies in the data, conduct research using internal and external sources to determine information is accurate.
· Resolve the data issues by following up with the end user.
· Coordinate activities and workflow with other data Stewards in the firm to ensure data changes are done effectively and efficiently.
· Extract the data from database and provide data analysis using SQL to the business user based on the requirements. Create pivots and charts in excel sheet to report data in the format requested
· Used VBA for excel to automate the data entry forms to help standardize data
· Assist CRM Analyst with Email Marketing Campaigns, including Client Publications, Newsletters, and announcements.
· Assist other data Stewards with Data Change Management (DCM) Inbox in resolving various tickets created by the User Change Request in Interaction Database.
· Developed and Created Logical and Physical Database Architecture using ERWIN.
· Designed STARSchemas for the detailed data Marts and plan Data Marts involving Shared Dimensions.
· Coordinated with different users in UATprocess.
· Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
· Ensured the feasibility of the logical and physical design models.
· Conducted the required GAPanalysis between their AS-IS submission process and TO-BEEncounter Data Submission Process.
· Configured the project on WebSphere 6.1 application servers.
· Deployed GUI pages by using JSP, JSTL, HTML, DHTML, XHTML, CSS, JavaScript, and AJAX.
· Communicated with other Health Care info by using Web Services with the help of SOAP, WSDLJAX-RPC.
· Implemented the online application by using CoreJava, Jdbc, JSP, Servletsand EJB1.1, WebServices, SOAP, WSDL.
· Used SAXand DOMparsers to parse the raw XML documents.
· Used Singleton, factory design pattern, DAO Design Patterns based on the application requirements
· Preparing and executing Unit test cases.
· Used RADas Development IDE for web applications.
· Involved in fixing bugs and minor enhancements for the front-end modules.
· Used Log4Jlogging framework to write Log messages with various levels.
· Doing functional and technical reviews.
· Implemented MicrosoftVisioand RationalRosefor designing the Use Case Diagrams, Class model, Sequence diagrams, and Activity diagrams for SDLC process of the application.
· Guaranteeing quality in the deliverables.
· Maintenance in the testing team for System testing/Integration/UAT.
· Conducted Design reviews and Technical reviews with other project stakeholders.
· Implemented the project in Linux environment.
· Created test plan documents for all back-end database modules.