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, Visual Basic, Excel, 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

EXPERIENCE:

Confidential, NORTH CAROLINA

Tableau Developer/BI Developer

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and publishing dashboards to tableau server.
• 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
• Ability to work in an agile environment.
• Working with different department to meet up with the project goals and deadline.
• 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.
• Supporting, maintaining, and monitoring ETL processes.
• Developing, and executing ETL packages to move data using stored procedures, functions, and SQL scripts in a Microsoft SQL Server environment.
• Analyzing, troubleshooting and identifying root causes of production issues.
• Deep understanding of ETL methodologies, Business Intelligence and big data Warehousing principles, approaches, technologies, and architectures including the concepts, designs and usage of big data warehouses and big data marts
• Managing big data architecture, controlling, and peering reviews in regards to data, security, and infrastructure.
• Creating queries and reports using reporting tools to create efficiency within the departments.
• Interfacing between raw data sources and front end reporting services using table linking, embedding, importing and exporting file conversion techniques.
• Producing and distributing monthly, quarterly, and annual reports using SSRS
• Leverage enterprise, business intelligence tools, SQL queries and other tools to develop complex models, dashboards, and reports, including Tableau.

Confidential

ETL Developer/SQL Developer

Responsibilities:

• 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.
• Supporting, maintaining, and monitoring ETL processes.
• Developing, and executing ETL packages to move data using stored procedures, functions, and SQL scripts in a Microsoft SQL Server environment.
• Support, manage, and maintain organizations clinical data in databases in SQL Server.
• Acted as an in-house Business Analyst to facilitate teams of Data and Business Analysts.
• Initiated meeting as a lead to understand / gather requirements and document processes.
• 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.
• 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.
• Selecting features, building and optimizing classifiers using machine learning techniques
• Acquiring data from primary and secondary data sources and maintain databases/data systems
• Identifying, analyzing, and interpreting trends or patterns in complex data sets
• Filtering and cleaning data, and review reports and performance indicators to locate and correct code problems
• Locating and defining new process improvement opportunities
• Extending company’s data with third party sources of information when needed
• Doing ad-hoc analysis and presenting results in a clear manner

Confidential

SQL Developer/Database Administrator

Responsibilities:

• Design and development of MS SQL Server database objects
• Help write and optimize in-application SQL statements
• Responsible for writing reports, big data analysis, query routines, and designing new applications
• Performing Data migration, cleansing and validation
• Data mining, big 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.
• 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