SUMMARY:

• 7+ years of Data Warehousing experience in SQL Server, Transact - SQL query development, QA Testing, Data Mapping, Data Modeling, Data Analysis, and Database Administration on MS SQL Server, Data Modeling and analysis on IBM mainframe SQL/DS database systems.

TECHNICAL SKILLS:

Application: S

BI/Reporting Tools: SQL SSIS, SSRS, SSAS, Informatica, Visual Basic, Excel, Ms. Word, Ms. Access, TMS Visio, Project and Office suite, Tableau 9.0, 10.1, 10.4.

Operating Systems: Windows 98-2003 Server, Windows XP, .NET,Windows NT, Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

• Created Rich dashboards using Tableau Dashboard and publishing dashboard to tableau server.
• Gathering the end user requirement from the business analyst to build a reports
• Interacting with business analyst to build an interactive dashboard that suit the end users/stakeholders requirement.
• Researching source data and designing queries that bring data into Tableau
• Developing complex interactive/dynamic dashboards with Tableau
• Data analysis, data discovery and data profiling.
• Creating document and implementing standards as well as complex modeling and enhance the capacity and performance of the Tableau environments.
• Responsible for Tableau administration, including server management, license administration, and version upgrades.
• Collaborating with Information Engineering personnel to ensure that the final presentation output meets the needs of the business, adjusting the output format as needed.
• Ability to reuse template/components/web services across multiple dashboards
• Communicating and collaborating with both business and technical teams.
• Performing Tableau administration with system upgrades, patches, performance tuning, issue resolution and debugging.
• Responsible for supporting Tableau Server installation, configuration, administration and maintenance.
• Translating data into intelligence that guides the decision-making process within the organization
• Delivering appropriate reports from Tableau based on need
• Gathering feedback and continual maintenance of dashboard
• Training internal stakeholders on Tableau reporting
• Designing and implementing ETL (extraction, transformation and loading) processes.
• Developing and modifying stored procedures and T-SQL scripts in response to validation exceptions
• Formulating logics for new systems, devises logic procedures, prepares flowcharts and data analysis through SSIS application.
• Storing and compiling data into a secure central repository
• Enforcing standards and best practices around data modeling efforts
• Assuring the integrity and the high quality of all work products
• Testing ETL to ensure the process functions as desired.
• Training different department on ETL processes
• Negotiating and documenting data owner permission to release data to customer.
• Deigning basic to moderately complex ETL processes and related database schemas.
• Developing moderately complex ETL objects, according to the design.
• Monitors developed ETL processes in production, and trouble-shoots production problems when they occur.

Confidential

ETL Developer /SQL Developer

• Testing ETL to ensure the process functions as desired.
• Training different department on ETL processes
• Negotiating and documenting data owner permission to release data to customer.
• Deigning basic to moderately complex ETL processes and related database schemas.
• Developing moderately complex ETL objects, according to the design.
• Monitors developed ETL processes in production, and trouble-shoots production problems when they occur.
• Maintain patients’ information in in-house database systems (Clear Health & Aries).
• Reporting on periodical basis for federal funding and grants.
• Working effectively and individually with Technical and Non-Technical team members
• Performing Data profiling and analysis of structured and unstructured data.
• Evaluating companies that provide supplier data and determining high value sources of information to supplement supplier data
• Provide ongoing statistical and financial analysis for payment system products. Perform payments revenue analysis and recommend strategies for increasing income.
• Supervise analysts in Payment Systems. Responsible for employee motivation and development.
• Provide best practices and support to business leaders with respect to policy enforcement, system enhancement recommendations, change management, and training.
• Defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
• Installing database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; document actions.
• Mapping data elements from client systems to target application for ingestion and processing
• Maintaining database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
• Interpreting data, analyze results using statistical techniques and provide ongoing reports.
• Assisting in the creating, delivering an organization of sessions, monitoring load times and re-arranging processes in increasing the efficiencies and effectiveness of the loading processes.
• Participating in customer meetings with Product Management to get a better understanding of Customer Ideas/Issues
• Participating in troubleshooting and resolving data integration issues such as data quality.
• Entering data, processing information and providing vital data/information to clients and supervisor
• Providing work estimates and communicate status of assignments.
• Performing Data migration, cleansing and validation
• Developing and maintaining SQL objects, Reports, Dashboards, as required and working with the functions to ensure accurate, consistent performance.
• Maintaining proficiencies in SQL Server, Tableau, Microsoft Offices, and Web based solutions.
• Supporting and promoting the integration and standardization of business systems and processes.
• Learning continuously and work independently and seek guidance from senior developers when needed.

Confidential

SQL Developer/Database Administrator

• Design and development of MS SQL Server database objects
• Help write and optimize in-application SQL statements
• Responsible for writing reports, query routines, and designing new applications
• Performing Data migration, cleansing and validation
• Data mining, data analysis, develops reports and queries for production, finance, sales
• Design and development of SQL databases, stored procedures, queries and performance tuning
• Developing supplier-naming conventions and ensure suppliers follow these conventions
• Evaluating companies that provide supplier data and determining high value sources of information to supplement supplier data
• Provide ongoing statistical and financial analysis for payment system products. Perform payments revenue analysis and recommend strategies for increasing income.
• Supervise analysts in Payment Systems. Responsible for employee motivation and development.
• Provide best practices and support to business leaders with respect to policy enforcement, system enhancement recommendations, change management, and training.