SUMMARY:

• A result - oriented IT professional with expertise on analyzing 100% of enterprise, human or machine generated data.
• Analyzed structured, semi-structured and unstructured data on large amount of information from virtually any source.
• Performed major functions for companies.
• Expertise in creating SSIS packages for integrating data from various RDBMS to SQL server database using BIDS 2008 and BIDS 2005
• Experienced in SQL Server and T-SQL in constructing Tables, Indexes, Views, and Stored Procedures.
• Experienced with ETL to transfer, cleanse and process data that is coming from different vendor to us.
• Understanding of data warehousing design concepts.
• Good understanding of operational, dimensional data model.
• Knowledge and experience with database design principles
• Experienced in creating Clustered and Non Clustered Indexes on Database tables to improve the system performance and applying various constraints on table to maintain integrity of data.
• Excellent interpersonal and communication skill, result oriented, and ability to learn new tools.
• Experience with Informatica
• Hadoop, C++/C, UNIX, Confidential Idol
• Experience with Unix scripts, debugging shell scripts
• Ability to work effectively as part of a team.
• Excellent interpersonal and communication skills
• Expertise in creating SSIS packages for integrating data from various RDBMS to SQL server database using BIDS 2008 and BIDS 2005
• Experienced in SQL Server and T-SQL in constructing Tables, Indexes, Views, and Stored Procedures.
• Experienced with ETL to transfer, cleanse and process data that is coming from different vendor to us.
• Understanding of data warehousing design concepts.
• Good understanding of operational, dimensional data model.
• Knowledge and experience with database design principles
• Experienced in creating Clustered and Non Clustered Indexes on Database tables to improve the system performance and applying various constraints on table to maintain integrity of data.
• Excellent interpersonal and communication skill, result oriented, and ability to learn new tools.
• Experience with Informatica
• Hadoop, C++/C, UNIX, Confidential Idol
• Experience with Unix scripts, debugging shell scripts
• Ability to work effectively as part of a team.
• Excellent interpersonal and communication skills

TECHNICAL SKILLS:

MS SQL Server 2005/2008 R2/2012

Talend, Tableau Desktop, Tableau Server

Oracle, Vertica Database

Scrum Agile

Amazon Cloud

Alteryx

Git

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Analyst

Responsibilities:

• Build Tableau reports including Tabular Reports, Matrix Reports, Drill Down and Drill Through Reports, List Reports, Parameterized Reports
• Perform and presented data analysis for complex data and files.
• Performed data manipulations using various Talend components like tMap, tJavarow, tjava, tVerticaRow, tVerticaInput, tVerticaOutput, tMSSQLInput and many more.
• Execute quality control checks in the form of SQL queries to ensure data integrity and enforce business rules.
• Process data from spreadsheets using Alteryx
• Involve in Vertica System Administration

Confidential

Sr Data Management Engineer

Responsibilities:

• Converted Cognos reports to SSRS Reports
• Installed and configured the Report Server on the Production Server and customized various settings using Reporting Services Configuration Manager
• Reviewed, analyzed and improved all the pre-existing stored procedures and SQL Scripts, also enhanced their performance
• Performed the Requirement Gathering and got involved in creating the FSD (Functional Specification Document) with the Business Analyst (BA)
• Created stored procedures, functions, triggers, cursors, SQL Scripts using complex joins and sub queries to retrieve the data from the database and return the processed data to SSRS Reports

Confidential

Business Analyst

Responsibilities:

• Created packages using Integration Services (SSIS) for extracting data from Flat Files, MS Excel files, OLEDB, MS Access to SQL Server.
• Worked with team to discover new productivity enhancement opportunities
• Worked with team to prioritize requests submitted from Confidential employees

Confidential, Boston, MA

DATA ANALYST

Responsibilities:

• Provide products, technologies, software, solutions and services to individual consumers, small to medium sized businesses and large enterprises, within the Government, Health and Education sectors.
• Twice awarded HP Recognition for Product Quality Improvements for troubleshooting data, system related issues and escalating appropriately to the development team.
• Extracted and reviewed data from heterogeneous sources such as MS Excel, Oracle, CSV files, Flat files, Text Format Data using SQL Server Integration Services (SSIS).
• Created packages using Integration Services (SSIS) for extracting data from Flat Files, MS Excel files, OLEDB, MS Access to SQL Server.

Confidential, Boston, MA

EDD specialist

Responsibilities:

• Performed and monitored standard EDD data processing functions (import, extraction of metadata, TIFF conversion, exports of data) on Confidential Workflow Document Management System in accordance with documented standard operating procedures improving quality.
• Analyzed business requirements and built logical data models that can describe all the data and relationship among the data using ERD.