SUMMARY

• 10+ years of programming, analysis, and statistical experience in teh Operation and management of teh business.
• 5 years’ experience of MS SQL Server 2016/ 2008/2012 , SSAS,SSIS,SSRS, Oracle 11g/12c, MySQL, PeopleSoft ERP system and Data Warehousing, Object Oriented Design (OOD).
• Professional experience on Load variety of large volume data files into SQL Server database tables, migrate Oracle tables and MySQL into SQL Server database tables.
• Hands on experience in high performance data integration solutions - Informatica PowerCenter and Microsoft SQL Server Integration Service (SSIS), and including extraction, transformation, and load (ETL) packages for data warehousing.
• Strong technical noledge in MS SQL Server development including Data Transformation Services(DTS), Microsoft Analysis Services(SSAS), Performance tuning, Reporting, Designing logical/physical databases Data Warehouse and Troubleshooting.
• Professional experience on OLAP and reporting tools wif data warehouses. Using Multidimensional Expressions (MDX) for querying and manipulating teh multidimensional data stored in OLAP cubes. Using SSAS database to develop including KPIs, Data mining, working wif changing dimensions.
• Professional experience of Creating Dashboards and complex reports in SSRS, SSAS, Tableau and Crystal Reports. Troubleshoot and resolve reporting issues.
• Proficient in Microsoft Office Tools- MS Access and Excel skills wif Pivot tables, vlook up, complex formulas, Macros and VBA.
• Hands on experience wif Hadoop ecosystem components like Map Reduce, HDFS, Hive, Pig, Hbase, Sqoop, Impala, Spark, and ZooKeeper. Implementing various data processing techniques using SQL/MySql, T-SQL, Hive and Pig scripts.
• Responsible for all aspects of SDLC including gathering of requirements, business and technical assessments, complex back and front - end designs, implementations, testing, data validation, training and development.
• Proven ability to approach problems. Effectively, prioritize and complete multiple tasks.
• Quick learner, Organization, take initiator, and hard worker, willing to take responsibilities.
• Designed data integration from difference database to data warehouse. Proficient star schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts. Created ETL packages using SQL Server SSIS Designer to extracted data from flat file, reformat teh data, and insert teh reformatted data into fact fable, loaded different types of dimension and fact tables into data warehouse, deployed packages and solutions into production.
• Developed projects using SQL Server SSAS wif Tabular Model, created data source/data source view/cube wif measure and dimensions, configured attributes of dimension table wif hierarchy relationships; modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS, deployed them to SSAS instance, trained teh model and queried teh model using DMX.
• Generated variety of business reports using SQL Server SSRS including matrix report, parameter reports, dashboard wif charts and drill down function; Configured report server and deployed reports on web server and Share Point 2010.
• Administerperformance and capacity management of teh BI Servers to provide a stable production environment. Ensure daily job completes at their schedule time wifout any data refresh issues and communicating wif teh downstream and stake holders in case of any variance. Take ownership of task assigned to team/me and keeping team engaged to ensure high performance.
• Analytical problem solving and debugging wif ability to quickly learn,
• Coordinates company financial planning, budget management, and comprehend business processed and problems in order to effectively develop technical solutions to their requirements
• Configured InformaticaPowerCenter, SQL Server 2016 and Oracle SQL 11G /12C or My-SQL database parameter files to adjust teh memory usage and file size.
• Created database tables wif various constraint including primary key, foreign key, etc.
• Loaded data from flat data files into SQL Server2012 database tables using BCP, Bulk insert, and table export/import; loaded data from flat data files and Excel sheet into Oracle database using SQL* Loader and SQL Developer.
• Extracted data from SQL Server 2012 database tables and Oracle database tables into flat data file and Excel sheet.
• Power user of advanced SQL queries wif multi-tables join, group functions, sub queries, set operations and T-SQL, C# or PL/SQL.
• Generated variety of business reports using creating T-SQL, CTEs, Poweshell scripting, Stored Procedures, Index, Triggers, and Views.

TECHNICAL SKILLS

Database: MS SQL Server 2016/2008/2012 , Oracle 11g/12c. My SQL, Access 2007/2010

Business Intelligence: MSBI, SSMS, BIDS/SSDT, SSIS, SSAS, SSRS, OLAP, PowerBI, InformaticaPowerCenter Express, SharePoint, TFS, Power Pivot/View, Tableau.

Reporting: Tableau, SSRS, SSAS, Crystal Reports, Access, Excel.

Language: SQL, T-SQL, PL-SQL, MDX, C#, VB.NET, JavaScript

Internet: HTML, Apache Web Server log, MS Share Point

Software: MS SQL Server, Management Studio/SSMS, Power BI, Toad, Linux, UNIX, Tableau Desktop 8.2, Tableau server, Hadoop and related tools, Cloudera, MS Office-Word, Excel, PowerPoint, Access

PROFESSIONAL EXPERIENCE

BI Developer (Scrum Master)

Confidential, San Antonio

Responsibilities:

• Working on OLAP & OLTP including Dev, Analysis, QA and Prod. Extensive programming noledge in T-SQL .NET framework wif Visual Studio.
• Working in an Agile environment as a Scrum Master leading and management for BI projects. Demonstrates ability to build effective relationships wif a wide range of people.
• Design data integration ETL packages from difference database to destination and data warehouse. Proficient star schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Working onSSISETL performance tuning, adjusting fast load techniques, clean data, debugging, error handling, event handling, re-running of failed packages using checkpoints, trouble shoot using break-points and other tuning techniques.
• Using several control flow tasks sequence container, For Loop, For Each Loop; ActiveX Script Task, CDC task in SSIS 2012, data flow task, Bulk Insert Task, Execute SQL, File System Task, and Script Task, Several Data Flow Transformations: Look Up, Cache transformation, Conditional Split, Derived Column, Row Count, Script Component, Merge Join and Union All.
• Designing teh SSAS OLAP cubes right from teh scratch, starting from gathering teh requirements, understand teh requirements, identifying teh dimensions and facts, designing teh dimensional model, create dimensions, time dimension, cubes, cube dimensions, dimension hierarchies, defining key columns, flexible and rigid relationships based on teh requirement, measure groups, calculated measures, cube partitions, cube aggregations, and processing cubes wif different conditions.
• Excellent analytical Report Life Cycle. Generated variety of business reports using SSRS including matrix report, sub report, parameter reports, and dashboard wif graphs, drill thru, drill down.
• Work wif Hadoop teh open source community and collect logs data from various sources and integrated in to HDFS, MapReduce, data cleansing techniques and Generating Statistics/Analysis, extracts for Tableau Dashboard reports.
• Collaborate wif Microsoft BI tools for teh Business Systems Analyst. Like SQL Server, ACCESS-FORM, EXCLE-MACRO, POWER PIVOT…
• Involved in Data mining using Enterprise Miner for various health care datasets such as Financial, Eligibility, Claims data, Inpatient, Outpatient, Long Term Care and Pharmacy (Rx).
• Manage reports for organization, as well as programming features that enable to extend and customize. Configured report server and deployed reports from teh projects in SSMS on web server and Share Point 2010.
• Extensively involved in doing user acceptance testing (UAT) and organized well wif customer service.
• Involved in version control of Reports and updating teh tasks completed using TFS.
• Highly motivated team lead wif excellent interpersonal and customer relational skills, proven communication, organizational, analytical.

Research Data Scientist

Confidential, San Antonio

Responsibilities:

• Successfully load teh data from ChIP-Seq and for DNA microarray, Load variety of large volume data files into PowerCenter, SQL Server database tables, migrate Oracle tables into SQL Server; managing Big Data wif MySQL.
• Retrieve and modify data using SQL Server 2008 and BIDS and Informatica PowerCenter from different database, participating wif teh business to identify Business Intelligence (BI) requirements.
• Created Technical Business Rules and ETL package for teh Data Migration Project, which assisted teh Project Management team wif present and future development goals.
• Design and develop multi-dimensional OLAP cubes and tabular models as per industry standards to satisfy business requirements. Mapped data between Crystal Reports, Data Marts and teh Enterprise Data Warehouse.
• Create stored procedures and Data Mining. Create Statistical modeling and implemented Analysis. Create interactive KPIs Chart or dashboards & reports using SSRS, automate & setup a process for collection of parameters/metrics.
• Statistical analysis usingSAS/ODS andSAS/views from oracle database tables into different formats like HTML and RTF. Test modeling methodology and validate models, management Metadata.
• Participated Data warehouse design. Strong noledge on relational database management (RDBMS) concepts and dimensional modeling, Database Logical and Physical models, Database Architecture, Data Mapping, Table Normalization (3NF), De-Normalization, DDL and DML.
• Using different biological database cross-reference other database wif Primary key, Foreign Key and linking their related noledge together.
• Proven ability to approach problems effectively, prioritize, complete multiple tasks and provide technical consultation.

Clinical Information Analyst

Confidential,

Responsibilities:

• Experience wif econometric modeling, credit scoring, portfolio forecasting and stress testing, data mining, software development,R, SASprogramming, statistical analysis, risk and response analytics, and new product forecasting.
• Involved in creating, reviewing and gaining approvals for initiatives/projects to deliver solutions in support of advanced data analytics enabling teh transition from disease management to a broader analytics.
• Proficient Created tables, indexes, table spaces, views synonyms, and integrity constraints. Implemented business logic using stored procedures.
• Write database procedures, functions using SQL statement and export data from Access to Excel, designed and developed complex reports for teh end user.
• Develop Data Entry Screens and Processor Forms. Troubleshoot on site issues such asdatatransfer errors.
• Importing and Exporting of Data between Spreadsheets and Access Database.
• Write VBA code for automated transferring of data between spreadsheets and other workbooks.
• Utilize data to streamline processes and improve financial, operations, pharmaceutical, research, and clinical outcomes.

Environment: My SQL, MS SQL Server, Java, Linux, MS Access, MS Excel, SAS, Advanced Statistics (I, II), Windows XP, Vista.