Sri Sai Vivek Annu

E-mail: ado5j5@r.postjobfree.com Cell: 609-***-****

Experience Summary

Over 6 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using SQL SERVER, ETL/SSIS (SQL Server Integration Services), SSRS and Crystal Reports.

Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.

Expert in writing scripts to provide solutions using Transact-SQL (DCL, DQL, TCL, DML and DDL) commands.

Building and publishing SSRS, Tableau, Power BI and Crystal reports utilizing complex calculated fields, table calculations, filters and parameters.

Designed and developed matrix and tabular reports with drill down & drill through using SSRS.

Experience in writing Complex SQL Queries involving multiple tables using inner and outer joins.

Experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.

Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, UML and Waterfall.

Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.

Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

Technical Skills

Reporting Tools : Crystal Reports, SSRS Reports, Power BI, Tableau and Qlik view

Programming Languages : C, C++, Java, HTML, UML, SQL, UNIX Shell Scripting, Python, CSS, Java Script, PHP,R

Database : SQL Server (2008, 2008R2, 2014), Oracle, MySQL, Progress OpenEdge and MS Access

Operating System : Ubuntu, Windows, Mac OS

Dimensional Data Modeling : Star Schema, Snowflake Schema, Fact and Dimensional Tables, OLAP, OLTP

ETL Tools : SQL Server integration Services, IBM Data stage

Microsoft Suite : Office, Word, Excel, Power Point

Professional Experience

Data Analyst /Business Intelligence Developer Nov 17 – Present

VanData LLC, Grand Rapids, MI

Vandata LLC provides Business Intelligence Solutions (Reporting, Database Management, Data Analytics and Web Development) to wide variety of companies in Printing, Packing and Manufacturing Sector Like Fortis, Great American Packing, Mccracken etc. As a Data Analyst/ BI Developer my role is to work with Clients to gather requirements, Analysis, Design, Test and Deploy using wide variety of SQL, Reporting and ETL Tools.

Responsibilities:

Translating business requirements into technical design specifications.

Depending on the requirement from the clients, creating different reports by pulling data from databases and displaying it on the report and monitor KPI’s.

Experience working in Agile Environment.

Experience in creating different types of reports like Sales Order, Collections, Purchasing, Inventory, Labels and Shipping Reports.

Experience working with EFI tool (ERP Software) which is used as a Front End for multiple clients.

Experience working with Raw data and converting into meaningful data/reports which helps clients to better organize things/data.

Developing different reports and Dashboards using SSRS reports, Power BI, QlikView and Crystal reports.

Experience working with ETL (SQL Server Integration Services (SSIS)) to transform data from Source to Destination.

Strong knowledge on importing data from various sources such as SQL Server, MS Excel and My SQL

Experience with evaluations and research methods.

Experience working with DCL, DQL, TCL, DML and DDL Database commands.

Experience in increasing efficiency of reports, reducing the run time of reports.

Performing testing by creating different test cases and test data using SQL.

ETL and SQL Developer Jan 17 – Nov 17

SV Steels Inc, Detroit, MI

SV Steels Inc was Detroit based steel and electrical company. As a ETL and SQL Developer my role was to work with ETL tool to Extract data from Source and transforming it using different stages (In ETL) and Loading into Destination.

Responsibilities:

Involved in gathering business, functional and non-functional requirements

Involved in creating mapping document.

Experience in Data Stage client tools like DS Designer, DS Director, and DS administrator

Experience working with different Stages like Complex Flat File, Dataset, Copy, File set, Join, Sequencer, Aggregator, Merge, Filter, Remove Duplicates, Transformer, Lookup, Funnel

Expertise in developing server jobs and parallel jobs by using all the stages which are available in data stage

Created/Exported data from source file then modified data according to the request and sent to destination file (Used Text, Excel and Databases as input and output files)

Experience in designing, compiling, testing and running data stage jobs

SQL/Reporting Development Intern Jun 13 – Jan 15

Efftronics Systems Pvt Ltd, India

Efftronics Systems is a leading Electrical company that develops LED’s lights, Data Chips and Batteries for wide variety of Clients such as Indian Railways, Ford, Tata Steel and Larsen and Toubro etc. They also work on developing Smart Cities, Smart Buildings and Smart Signaling. As a SQL/Reporting developer my roles was to gather data as per requirement and develop reports that helps company to know how much quantity to produce/ship/order to meet the demand.

Responsibilities:

Experience working with software development life cycle (SDLC)

Designed solutions and reports based on specific requirements using SQL Server Reporting Service (SSRS)

Involved in analyzing and designing of the design documentation

Wrote SQL queries on multiple tables to get the desired data

Experience working with large datasets, joins, subqueries, functions and filters

Involved in designing database, SQL queries optimization and performance

Created SQL Agent jobs and schedule Reports to run overnight. Resolved issues if job fails

Involved in website design using HTML, CSS

Involved in connecting website with social media like Facebook, Twitter and Gmail

Education

Texas A & M University (Tamuk)

M.S in Computer Sciences

Vignan University (VU)

B.Tech in Computer Sciences

Contact this candidate